Just wondering what your opinions where on how the user should enter information into a table without actually going into the table view? Thanks.

The short answer is a bound Form.

I forgot to explain this but the data on the form needs to be from two different tables. But when i create a form from a query that includes both tables and try to enter new information with the form it tells me that is can't find a certain field. For example an ID field. If its a new ID that is not already in the Database it will not insert it into the table. Does that make sense?

Are the tables related?
Is the query updateable?

So many questions to ask...

Are your tables related?
Have you thought of a sub-form?
Is the ID an autonumber field? On both tables?

Can you provide a little more detail on your tables?

Here is the database with the two tables in it. I have put a made up record in there to show you how the tables are related.

See the attached.

I added some primary keys that are autonumber and updated your insert appt form.

Is this what you want?

Edited by: HiTechCoach on Thu Jan 18 16:14:56 EST 2007.

Cool Thanks.

You're welcome!

Glad we could assist.

Good luck on your project ...