requery 1

[ignacious]

I use a database to assign in shop part numbers to items. On my data entry form I have a subform that shows the last serial number assigned from a query against the table. I also have a command button to enter another record instead of closing and re-opening the form. I am having a problem getting the subform to requery/refresh with the newly assigned part number without closing and re-opening the data entry form.

Thanks for any help

 

[cghoga]

You might try recalling the Subform RecordSource.

Hope this helps.