Mary you are Miss God!!!!
Thank you very very much, and all the other people that helped on that long route of me giving the right information.
Cheers...
User Profile
Collapse
-
Ok all, let's see if i get it correct this time!!!
Right, first of all the row source is: SELECT [PARTS].[PART NUMBERS], [PARTS].[TARGETS] FROM [PARTS] ORDER BY [PART NUMBERS];
The combo box is called: PARTS
And the text box is called: TARGET
I hope this covers everything you need
Thanks for your patience.
Cheers...Leave a comment:
-
hi!
no i mean a number sorry (each part number has a target number, e.g. so part ABC1 has a target of 50 per hour)...Leave a comment:
-
hi!,
table: COLUMN 1 (PART No) / COLUMN 2 (TARGET)
ABC1 / 50
what i am trying to do is select a part from a combo box on the left of the form which works fine as it is linked to my table e.g. above, so when i select a part (ABC1) in my combo box, i want the target figure to automatically appear in a text box on the right of the form.
cheer...Leave a comment:
-
hi!,
combobox name is combo1 and the row source is table/query.
cheers...Leave a comment:
-
populate textbox after selecting combobox value
hi!
i have a simple table in access with columns labelled (part numbers) & (targets).
in the form i have designed i have a combo box linked to this table and i also have a text box in the form as well, what i am trying to achieve is when a part is selected in the combo box is automatically puts the target figure in the text box.
can anybody help me as well, to put it bluntly i'm useless!!
...
No activity results to display
Show More
Leave a comment: