Auto fill fields when we use Barcode or ItemName

[Mehvan]

Hello Everyone

How can I Auto fill fields , when I choose Barcode or ItemName ?


it auto fills fields when I choose Barcode , but When I choose ItemName only auto fill price field , Barcode doesn't fill .
Database1.zip

[Gicu]

Remove the on error resume next and you will see why. You will need to rethink the relationships and your table structures.

Cheers,
Vlad

[June7]

1. change form RecordSource to just ID table

2. change combobox properties:
ControlSource: Barcode
RowSource: SELECT Barcode, ItemName, Price FROM Items;
ColumnCount: 3
ColumnWidths: 0";1.0";0.5"

3. change Price textbox ControlSource to: =[ItemName].[Column](2)

4. eliminate the VBA

5. change ID field in ID table to autonumber or delete the field because it is not being used for anything

6. give ID table a better name

[Mehvan]

thanks a lot
I solved it , I changed ItemName and Barcode to Combo box , and I removed relationship between barcode , I made relationship between ID