Hello
have been reading through all the similar threads but still can't manage this to work.
here's what i have:
In my form "ABrep" (source is table "Bway"
i have a listbox which lists all the entries from table "Away". The listbox shows the entries in the following manner:
A_ID/A_Name/A_City/A_Country
Table Bway has the fields B_ID/B_Name/B_City/B_Country which are shown in form ABrep with the same names.
The value saved for later use when selecting a line in the listbox is A_ID.
What i would like to acchieve:
When the user selects a line in the listbox, for example:
30/Murph/Caracas/Venezuela
i want the fields B_ID/B_Name/B_City/B_Country show exactly 30/Murph/Caracas/Venezuela as well.
The user should be able to edit and save this as new record in table Bway. When the user selects another line in the listbox this must be changed in the fields also.
Hope to find some hint/direction on how to solve this.
Any help gr8ly appreciated.
Cheers
Chris
have been reading through all the similar threads but still can't manage this to work.
here's what i have:
In my form "ABrep" (source is table "Bway"
A_ID/A_Name/A_City/A_Country
Table Bway has the fields B_ID/B_Name/B_City/B_Country which are shown in form ABrep with the same names.
The value saved for later use when selecting a line in the listbox is A_ID.
What i would like to acchieve:
When the user selects a line in the listbox, for example:
30/Murph/Caracas/Venezuela
i want the fields B_ID/B_Name/B_City/B_Country show exactly 30/Murph/Caracas/Venezuela as well.
The user should be able to edit and save this as new record in table Bway. When the user selects another line in the listbox this must be changed in the fields also.
Hope to find some hint/direction on how to solve this.
Any help gr8ly appreciated.
Cheers
Chris