Access 2000 Query append question

[Guest]

I use an append query to add a record from my master file table to a current
job file table. It works from a command button on my input form that prompts
for an ID number. Unfortunately the imported record never shows as the active
record (it sorts alphabetically by default into the table), nor do I get an
error message if the query returns no record. I would appreciate any
suggestions as I am a VB beginner.
Thanks, Dan at Munlake

 

[Guest]

Create unbound textbox for your form with record source like--
[YourGoToTable].[IDField]

In your append query add a field like--
X: [Forms]![YourForm]![YourTextBoxIDField]+1

 

[Guest]

Thanks, Karl...but I cannot make it work after many attempts. The query does
not retain the expression I enter, so I must have something incorrect. The
master file table in this case is on a network drive that is linked to the
database if that makes a difference. Should I refer to the source table or
the local table for the textbox?

Create unbound textbox for your form with record source like--
[YourGoToTable].[IDField]

In your append query add a field like--
X: [Forms]![YourForm]![YourTextBoxIDField]+1

I use an append query to add a record from my master file table to a current
job file table. It works from a command button on my input form that prompts
for an ID number. Unfortunately the imported record never shows as the active
record (it sorts alphabetically by default into the table), nor do I get an
error message if the query returns no record. I would appreciate any
suggestions as I am a VB beginner.
Thanks, Dan at Munlake