Access 2000 Query append question

D

Dan at Munlake

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
 
K

KARL DEWEY

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
 
D

Dan at Munlake

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?

KARL DEWEY said:
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


Dan at Munlake said:
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
Click to expand...
Click to expand...
 
Top