Form with subform

[dah]

Hi,

I am still having a bit of trouble getting my database information to come up automatically in the form I created. I want to just type in an ID number and have all data come up associated for that particular person.

Also, I would like to be able to add a new record (for someone who is just attending a workshop for the first time) from the form. As this point, I cannot add a new record. I get an error message telling me that I need a record in the actual table.

I don't know where else to go at this point.

Thanks

 

[Hayley Baxter]

Your from will be based on either a table or a query so you'll have your main form and your subfrm. Probably the best way is to put a combo box on your form and from the wizard select option3 to find a record on your form. If you really do just want to type in a number you could put [Enter Number] as the criteria for your query and this will do the same thing.

To add a new record place an add cmdbutton on your form.