Newbies AJE Posted February 15, 2006 Newbies Posted February 15, 2006 Is there a way in MF to auto advance to the next field once data has been entered. I'm am working on an inventory app and we use barcode scanners to inventory the parts on our trucks. I have 2 fields in the count table. Part number and qty. When I scan a part number the scanner includes a to advance to the qty field. I want the qty field to default to 1 and move to the next part number field (next record). This way we can just go thru the truck scanning everything and not have to worry about stopping and entering a qty. I can then run a summary report for the qty of each part. Thanks Jason
sbg2 Posted February 15, 2006 Posted February 15, 2006 1) Qty field set File>Define Database>Qty field>Options->Auto Enter->Data to "1" (w/out quotes) 2) Right click the Qty field on the layout you are using, Left Click Field Behavior, Uncheck "In Browse Mode". 3) If you will later need to enter the Qty field in Browse Mode make the field a button and attach a script "Go To Field[Qty}" when then the field is clicked. Or simply use a different layout to edit than for scanning entry.
Newbies AJE Posted February 16, 2006 Author Newbies Posted February 16, 2006 Thanks, I'll give that a try. Jason
T-Square Posted February 16, 2006 Posted February 16, 2006 Alternatively, after #1 in sbg2's post, create a list layout with just the part number field on it. If you default to QTY=1, then you don't need it on the layout, and you can have a very simple layout for the truck scanning without affecting other parts of the interface.
Recommended Posts
This topic is 6918 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now