I have a data entry form. The form is based off of a query which show Field Name, Well Name, Well Number.
I would like to be able to choose a field and for the next combo box to show only the well names for that field. I have looked up cascading combo box and I cannot get it to work. I am having a serious brain fart.
The combo boxes are bound boxes. The first combo box is Field ID, the second combo box is Well Name. Any help would be greatly appreciated. Thank you.
You might be having the same problem I did a while back. For the first query, have an autonumber primary key. For the second query, set the foreign key type to number (since the autonumbered primary key in the first query is just a number in the second query). I pulled my hair out for a month before I figured out what I was doing with that thing.