NEW TO ACCESS PLEASE HELP

[hohai610]

Hello everyone
I'm trying to make a POS cashing form(i have a database table).i have 3 fields(UPC,UPC1,UPC2) in the table with different codes.
I would like to create a form that contains a text box and a list box when i input a code into text box , it will automatically search in UPC then UPC1 then UPC2 until getting the match record and input that one into list box then save that record into the list box and continously input more records when i change the text box data
Is there any way to do so?
Thank you so much for your time

 

[arnelgp]

use a Combobox with 3 Columns for UPC, UPC1 and UPC2.

 

[theDBguy]

Hi. Welcome to AWF!

This sounds like you may have a "repeating group" in your table, which would be considered a bad design. Can you show us your table structure?

 

[hohai610]

Hi. Welcome to AWF!

This sounds like you may have a "repeating group" in your table, which would be considered a bad design. Can you show us your table structure?

Thank you for your reply Mr the DBguy
This is my stock tabe structure .The reason why I created 3 fields of UPC is because UPC is for company code(that is for managing inhouse system). UPC1 & UPC2 are the number on the barcode of the items i got from the suppliers . But sometimes they change the barcode number so i have 2 different barcodes for the same item.So to make it easier for cashiers .i would like to make a Form in Access ,when cashiers scan the barcode into text box it will search in UPC1 ->UPC2 until get the match record.
Is there any better way for me to make it easier .Please give instruction .

 

[hohai610]

Thank you uncle Gizmo
if I put only 1 UPC in the stock table, we don't have space to put more than 1 barcode number when the supplier change the barcode of item and we still have the previous barcode in stock
I'm glad to learn more about your tool .How can I contact you ,sir?

 

[hohai610]

Thank you so much Mr Gizmo
i will try your tool
In the past i used a free pos software for the business. but i need more features than what those software has>So i came up with the idea that i will learn Access and use VBA to write a POS system for myself. i started with creating a Checkout (cashing) form.I don't want to spend time to look up for the product name in the stock table .just want the cashier scan the barcode and the product info (description, unit price, tax, qty) showup on the subform or listbox
RIGHT NOW I HAVE 2 PROBLEMS
1. IM ABLE TO SEARCH IN ONLY 1 FIELD WHEN I HAVE MORE THAN 1 BARCODE FIELDS
2. AFTER IT SEARCHED AND PUT OUT THE MATCH RECORD INTO LIST BOX .HOW TO MAKE THAT RECORD STAY IN THE LIST BOX OR SUBFORM ( BECAUSE WHEN I CHANGE THE TECTBOX 'S DATA THE PREVIOUS RECORD WILL DISAPPEAR

 

[hohai610]

that is exactly what I'm trying to do for my project .Can you give me more details and hints to know what to do or steps to learn
Very appreciate your help Mr Gizmo

 

[hohai610]

I thank you so much for your opinions and your experience . I will follow those steps and see how much i can learn
These are very useful with new person like me

 

[hohai610]

good day Uncle Gizmo
I was looking over your code and your video . But to be honest to you , I really doesn't have any ideas how to create those forms or what are those variables in the code use for ?
Can you please elaborate more for me please? like what type of forms that you use
and name of those text box or names of bound text boxes inside the forms please .
Very thank you for that sir