Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RECORDSETCLONE w/ different fields from different forms

Status
Not open for further replies.

schredder

Technical User
Feb 6, 2003
48
AE
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







 
Can this be done with recordsetclone? Or do i have to go in another direction?
Thanks in advance for any help
Chris
 
So think I have to help myself. Think the right direction is working with Dlookup for every field in table "Bway".
Still would be very thankful for some sample code/help since the Access implemented help is not enough.
Thanks
Chris
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top