Search results

Linking Combo Boxes - Help Hi all, Ive attached a test db to this post so u can all see wot im trying to do here. Ive basiclly got 3 tables with fields: tblCar: Make, Model, Mileage tblMake: MakeID, Make tblModel: MakeID, Model If u look at the relationships ull see how ive set them up...

Yep that sorted it m8, thanks alot for the help :)

the control source property is blank on both combos. I take it this will effect it?

Thanks for the speedy reply mate - very appriciated. The form tblMachine goes straight back into the table, theres no query. Would i need one to do what i need? and how would it be structered? Thanks

Hi all, Ive got a form called frmAddMachine, which adds a new machine to a table called tblMachine. tblMachine has the following fields: MachineID, Make, Model, SerialNumber, YearManufacture, RegNumber. I have also got 2 other tables: 1 called tblMake and 1 called tblModel. On frmAddMachine ive...

I think it was m8, ur right. I get confused easily. The bit i was wrong with was the syntax for qdelDeleteClient query. Ur syntax was right and when i replaced it with the old syntax it worked. Thanks for all ur help. ps. No doubt u will b seeing me on these forums again many a times with...

Got it working :), it was a mix of what you said. This is what i did:- The Row Source for List0 is: SELECT tblClient.ClientID, tblClient.LastName, tblClient.FirstName FROM tblClient ORDER BY [LastName]; This displays the clientID, lastname, firstname in the listbox, i set the first column...

ah yeh. That would work well and would be alot easier to do, however i want my system user to see the client lastname and client firstname so they can relate to who the client actually is, because they wont be able to tell which client is which by looking at the ID. Is there a way i can have the...

Hi all, Im new to access and i need some help. This is my situation. I have a listbox (called list0) on a form (called frmDeleteClientContact). The listbox displays a list of clients by Lastname and Firstname from table tblClient. tblClient contains other fields but they are not relevent as all...