Search results

Thats great thanks, and almost exactly what I need, but how would you then take that data selected, and store it in a different table, say to record that the option has been chosen? i.e. if on the same form you had a text box for someones name, which was manually inputted, and then you select...

I think you missunderstand, or I do - the data already exists, but only in a table that is designed to feed a combobox. The operator then chooses a value from the combobox for which part has failed. (From table Parts, which contains 2 columns Parts, and Area relating to where the part was...

Colin, I have tried your suggestion but cant get it to work, I just get an error message. I think we may be talking at cross purposes though because surely if you put the DLookUp function in the control source you cant use the control source to store the selected item in the main table. Could...

Thanks very much. I'll give it a try - but not today 'cos home is calling.

Yeah I've played around with a DLookUp function, but just cant get it to work. Probably missing something simple.:(

No, only the one.

Hi, I have what seems to be a very simple problem, but I just cant work out how to fix it. Within a database I have bodged together with limited know-how and alot of luck I have 2 combo boxes on a particular form. One lists all parts of an engine that could fail and the other lists all the...