Question: Master Form with Multiple Subforms Problem

[KCC47]

Sorry, I have been indisposed for a few weeks.



Just so I understand, you are suggesting that I concatenate the names in the combobox but forget the code for the Applicant_Add_Frm?

Where does the concatenate code go? In the row source for the combobox in the Applicant_Junction_SubFrm?

[KCC47]

I have a new issue.

When I select a rejection reason on my master form, it comes up with the following error: "The value you entered isn't valid for this field"

Now, I know why this is coming up. I have the combofox setup to store the value in the Rejection_Reason_Junction_Tbl. If I fix the issue to store the ID field, it only shows a PK in the master form after I select it. Is there a way to show something other than the PK in this case?

[June7]

Yes, concatenate the name parts in the combobox RowSource and forget trying to pass name and parsing with code for new record. Names just have too much variability.

To set up multi-column combobox review http://datapigtechnologies.com/flash...combobox3.html

[KCC47]

I'm getting a syntax error(missing operator) in the query expression. I'm not sure what's wrong.

[June7]

Post the query SQL statement for analysis.

[KCC47]

Sorry, but where would one find that?

[June7]

Maybe from the combobox RowSource property? Or if the RowSource is a reference to query object, open the query in SQL View.

[KCC47]

Would it be easier for you to review the database itself?

[June7]

What is name of form with the issue?

[KCC47]

Applicant_Junction_SubFrm

[June7]

RowSource SQL is missing a paren. Sorry if that was my typo.

SELECT ID, Last_Name_Company_Name & IIf(Not IsNull(First_Name), ", " & First_Name, "") & IIf(Not IsNull(MI), " " & MI,"") AS AppName FROM Applicant_Tbl;

ColumnCount: 2
ColumnWidths: 0";2"

[KCC47]

Are you getting this same error when you attempt to open the Rejected_Application_Frm: The expression On Open you entered as the event property setting produced the following error: Return without GoSub.?

I can't text whether or not the fix in the last post is working because of this?

[June7]

Not getting that error. The RowSource edit will not impact.

[KCC47]

Nevermind that last error.

Just to confirm, I'm to input this code into the rowsource of the combobox of the Applicant_Junction_SubFrm?

I've done that and nothing is changing. I still get the notinlist error when I enter anything in that field.

[June7]

I don't get NotInList error with any comboboxes in the subforms of Rejected_Application_Frm.

If you have done the same edits then your db should work as well. I would have to see exactly what you have done.