Queries Using A Form

[notoca]

Hi

I've been searching the archives for an example of how to use a form to capture user input for a query. I found an example and pulled it to pieces to find out what it was doing. I was even able to follow some of the VB code amd I learnt a few things. So, feeling a little confident I started to build a query form based on the example.

It's complete and almost works properly. The program falls over when it comes to the following dim statements:

DIM db as DAO.Databases
DIM qdf As DAO.QueryDef

The message I get is "User Defined Type Not Defined." These were in the code of the example and they worked fine with the example. However, in my project the query form falls over at this point. I looked through the example vb code trying to find references to DAO but couldn't find anything. There is something in the example program that I have missed. Does anyone have any ideas.

Thanks

 

[Dugantrain]

I'm starting to think that the DAO Reference issue should be in the FAQ's:
http://www.mrexcel.com/board2/viewtopic.php?t=72405

 

[notoca]

Thanks Dugantrain. That did the trick.