Adding a blank record to a query

[DeeDee77]

I have a form that is based on a query in which the user enters data. Is there any way to make the form open to a blank record instead of the 1st record in the query? Thanks for any help!!

 

[Rich]

Do you mean a blank record or a new record?

 

[DeeDee77]

New Record, Sorry!!

 

[Rich]

Look up the GoToRecord method

 

[DeeDee77]

It won't allow me to add a new record to the query, because there isn't a new record to go to. It is full with the info. from the 3 tables, and there is no new record at the end.

 

[Pat Hartman]

Sounds like the query is not updateable. Open the query directly to determine this.

 

[DeeDee77]

I figured it out. I had the relationships messed up. Thanks!!