Combo Box returns null value when Child Link has no related record

B

Barry

I have a form (that contains a combo box) and a subform (which contains a
datasheet). The Combo Box has unique values, while the datasheet has many
values, including the same field as the combo box. I have tried relating the
tables, joining them in queries (plural because I had one query with only the
combo box field and another querty with multiple fields for the datasheet).
I now have them linked in the form (with the combo box being the Parent and
the datasheet as the Child). For some reason, when selecting a value in the
combo box, which does not yet have a record for in the datasheet-based table,
the selection changes to a null value following it's selection. The problem
with this is that I have a macro setup to populate the field in the
datasheet, based on the value of the current combo box selection, when
clicked. It returns an error on the values discussed above, due to the fact
that they are null, stating that cannot enter a null value. I have broken
all links in queries, emptied the OnClick event completely, and the combo box
still reacts the same. Anybody ever had this issue?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Link a text box based on drop down box with four options MS Word 365 0
Combo box 0
Combo or list box 0
Trouble Filtering a Sub Form With Combo Box Options 2
Requery Combo box in popup form 2
Filter Datasheet based on Combo Box selection 3

Top