I don't know, these new users bombarding the forum with queries...!
I have another problem which I suspect is related to the problem in my previous post...
I have a form which I have created from a query in order to enter some autolookup data from a table into a field (Field1), based on what data the user puts in another field (Field2).
This works fine if Field2 is a text box and the user types in the information manually. However, I need it to be a ComboBox. If I the source information for the ComboBox comes from the query, there is no info in the drop-down. If it comes from the relevant field in the original table, the options are there, but Field1 does not update and instead displays a Jet engine error, saying it can't find a matching field in the related table.
Any help would be very gratefully received.
Chris
I have another problem which I suspect is related to the problem in my previous post...
I have a form which I have created from a query in order to enter some autolookup data from a table into a field (Field1), based on what data the user puts in another field (Field2).
This works fine if Field2 is a text box and the user types in the information manually. However, I need it to be a ComboBox. If I the source information for the ComboBox comes from the query, there is no info in the drop-down. If it comes from the relevant field in the original table, the options are there, but Field1 does not update and instead displays a Jet engine error, saying it can't find a matching field in the related table.
Any help would be very gratefully received.
Chris
