Creating a Special Recorded Mail Database

[mikehextall]

Hi all, I am trying to create a Special Recorded tracking database where a member of staff will log the tracker number into the database and then at a later date someone can come and update the data, what I want to do is scan the tracker barcode with a scan gun and its details appear for updating, I can do this part but when I make any amendments to the data it doesn't save the new data and I don't know why? I am using a combobox to display the tracker number and me.text1.value = me.combo4.column(1) and so on and so forth to display the data, when I change this data it doesn't save.

Please help.

 

[G37Sam]

A barcode scanner (or at least the ones I've used) act no different than a keyboard. So what you're looking for is basically a textbox that would filter out a record in your form on its Before Update event.

There are two ways that I use to filter:
1) filter property & filterOn method

OR

2) Change the forms recordsource property and requery'ing the form

Hope that helps