JoeyGaspard
Board Regular
- Joined
- Jul 22, 2019
- Messages
- 162
I have an access form that gives the user the option of populating 5 fields with a barcode scanner input, but they may only need to populate 2 of the fields. Is there a way to use an if statement in those fields to add that record?
This is for supply purchases, they may scan up to 5 items, but never do, its usually 2 or 3, but I have to give the option just in case. I want them to use only a scanner on this, so I have a barcode that simply inputs 9999 into whatever field they are on field, and I am trying to use an after update event to say basically this: If textbox1 = 9999 then Add Record, else, move to the next line? Also, after they scan a barcode, it automatically moves the curser to the next available field, that is why I was hoping the after update would work, I just dont know how to code it? Any help is greatly appreciated, and thank you in advance:
This is for supply purchases, they may scan up to 5 items, but never do, its usually 2 or 3, but I have to give the option just in case. I want them to use only a scanner on this, so I have a barcode that simply inputs 9999 into whatever field they are on field, and I am trying to use an after update event to say basically this: If textbox1 = 9999 then Add Record, else, move to the next line? Also, after they scan a barcode, it automatically moves the curser to the next available field, that is why I was hoping the after update would work, I just dont know how to code it? Any help is greatly appreciated, and thank you in advance: