Delete and create new form every time I change the tables?

[gypsylady]

I am very frustrated that every time I make a change to a table I have to delete the forms completely and start over. For instance, I used the lookup wizard in one table that looks at values from another table. When I needed to add another record into the table, the new record does not show up on the form.
Any advice?

 

[THoey]

You shouldn't have to recreate the form if you are adding records to the table. You probably need to requery the table before you can see it in your recordset.

If you are talking about redesigning the table, like adding a new column, even then, you should just have to create a control on the form and use that field as it's record source.

Hope that helps. Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.