Here it is.
Thank you
Here it is.
Thank you
Set combobox ColumnHeads property to No.
There is no data in Applicant_Tbl. So anything you type into the Applicants combobox will trigger the NotInList error. Put data into table. Same goes for the VIN combobox.
If you want to add VIN and Applicant records 'on-the-fly' then use the NotInList event to accomplish that http://support.microsoft.com/kb/197526.
Should the Rejection_Reason_ID combobox LimtToList property be Yes?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Can I just use the code from post# 26?
I would put the first part in the Applicant_ID_ComboBox of the Applicant_Junction_SubFrm, and the second part in the Applicant_Add_Frm?
Wow, forgot already discussed code for NotInList event.
Yes, could apply the same concept, just modify code appropriately.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I'm getting closer, but now a new error is showing:
Option Compare Database
Private Sub Form_Current()
If IsNull(Me.ID) Then Me.ID = Me.OpenArgs
End Sub
It debugs after it asks the question "Do you want to add this applicant?" the underlined section is highlighted? This is in the Applicant_Add_Frm
Can't pass ID because that is an Autonumber field. It is not the ID that should be passed it is other data, like name.
Also, just realized trying to pass a name to the Applicant_Add_Frm is too complicated. Did you and I already have that discussion or was that another poster?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
No it was me. So should I just forget putting the onload event procedure on the Applicant_Add_Frm?
Yes, I seem to remember that was the determination.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Wonderful, that appears to be working.
Is there a way to search for records in the Applicant_Tbl on the master form? I get an error message if I attempt to search in the subform control?
Bound controls cannot be used to input search criteria. Also, a subform cannot control the main form (children do not command parent).
Parameterized query is one way to filter forms and reports. I don't prefer that method but it is easy to do and requires minimal code.
Review http://datapigtechnologies.com/flash...tomfilter.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The remainder of my questions relate to a report using this master form. Should I start a new thread in the report section?
Might be a good idea if the question gets into new territory. Can always include a reference to this thread.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you for your help here June7. I've done just that in the report section. I'm marking this thread answered.