I'm a newbie in doing MS Access Forms.

I would like to create a form that will input data to a table.

In order to get the PropertyName, I have a query that gets that joins
the PropertyId to a different table to extract the PropertyName.

I use this query in my form to update my table.

In the form, I created a command button to insert a new record.
This is where my problem occurs. I get a popup box "You can't go to
the specifice record".

Any ideas.

On Jan 31, 11:52=A0am, martinbr_2... [at] yahoo.com wrote:
> I'm a newbie in doing MS Access Forms.
>
> I would like to create a form that will input data to a table.
>
> In order to get the PropertyName, I have a query that gets that joins
> the PropertyId to a different table to extract the PropertyName.
>
> I use this query in my form to update my table.
>
> In the form, I created a command button to insert a new record.
> This is where my problem occurs. I get a popup box "You can't go to
> the specifice record".
>
> Any ideas.

Make sure both tables have a primary key on PropertyID.