To view the current record in the form

[aman]

To display the current saved record in table on form statusbar

Hi guys

I have designed a project in access. In the input form users enter the location,department and scan the barcode .The barcode is scanned in the textbox and I have used the lost focus event on it to save the record in table so that users can scan as many barcodes as they want with same location and department.

My client asked me that sometimes they get confused whether they have scanned particular barcode so by mistake sometimes they scan them twice or sometimes don't scan them at all. Is there any option I can use either at the status bar to view the information just entered or subform to display current saved record in the table.

Regards
Aman

 

[RuralGuy]

The only useful item you could display is the last barcode saved which you could display on another TextBox (unbound and locked) on your form or on the status bar if you want. You would use the same Exit event to display the value.

 

[Scooterbug]

You could also put a listbox on the form and make the record source a query based on the table that is storing the barcode. Just requery the listbox after the barcode is scanned in.

 

[aman]

Hi guys

could you please tell me how to display the value of a textbox on statusbar?

Thanks
Aman

 

[RuralGuy]

SysCmd acSysCmdSetStatus, "Your TextBox has a value of [" & Me.YourTextBox & "]"

 

[aman]

Thanks a lot RG

It worked absolutely fine...

Cheers
Aman

 

[RuralGuy]

Glad I could help.