Yes you can lookup (i.e. SQL select) to determine the correct row, but your dependant table will need the autonumber. An example is CUST and ORDER, ORDER_LINE from northwinds. ORDER will need the autonumber of CUST to link to that data, and ORDER_LINE will need the autonumber of ORDER to link...
gaijin, on page one of the zip files is an access mdb titled 25comb7. download it, when launched it will sgow a dropdown box of 25 examples of combo box controls. one is single and multiple tranfers from box A to box B.
Bob I could not have said it better.
We also use similar under Oracle OBDC. The Securty tables can be very complex, but must be thought out by a good planner. When done right, like yours, an application and restrict down to add/chg/del in any app or form.
'Reset the Email notification/DELETE fuction visable FALSE when JOE/462 or BECKY/066
Me!btnEMail.Visible = True
Me!btnDelete.Visible = True
If ((GetUserID() = "KOP00462") Or (GetUserID() = "KOP00066")) Then '
Me!btnEMail.Visible = False
Me!btnDelete.Visible = False
End If
The default is...
trry this site. while in German, the combo box example is rather nice.
http://hjem.get2net.dk/accessnet/download1.html
25combo7, is in ACC97, but can be converted. scroll to bottom of list and there is one which allows single/multiple copy to 2nd combo box.
gymratpa@ziplip.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.