Refresh query

[Dougalsworld]

I have a form linked to two talbles:

tblData
MaterialID (Autonumber)
MateialCode (Manually entered catalogue number)

tblBarcodes
Barcode ID
Barcode

The barcode ID is basically a list 1,2,3,4,5 etc against a list of usable barcodes and the idea is in my form frmEntry I will add a new Mateial, this inturn generate an autonumber, this shows on the form ok, and this in turn is linked to the BarcodeID to return a usable barcode for my new Material.

Problem was this doesnt happen when I add a new product. If I use the form to look back at previous entries it works fine, it's only the current record that doesn't automatically update.

Is there a simple way to refresh the form?

many thanks

 

[neileg]

Subsititute queries based on the tables, for the tables in your form. Then in the After Update event of the text box used for the new product add Me.Requery.

 

[Dougalsworld]

I've done this and as much as it updates the query it also moves the form on to the next record.

I need to update the field while remaining within the same record, is this possible?