Subforms still not working

[Colin Foster]

I'm going to try again on this issue as, maybe, I didn't explain it clearly
enough (MacDermott/Turtle tried to help, but I'm still having
problems!)...so here goes...

TblProject
Project ID (Autonumber)
Other fields as necessary

TblQuote
QuoteID (Autonumber)
ProjectID (Number)
Other fields as necessary

TblEnquirer
EnquirerID (Autonumber)
Other fields as necessary

TblProjectEnquirer
ProjectEnquirerID (Autonumber)
ProjectID (Number)(lookup as combo box to TblProject)
EnquirerID (Number)

Forms are based on these tables.

FrmProject
FrmQuote (as subform linked to FrmProject via projectID)
FrmProjectEnquirer (as subform linked to FrmProject via projectID) - shows
all three fields
FrmEnquirer (as subform linked to FrmProjectEnquirer via enquirerID)

What I need to be able to do is to create a new enquirer within the
frmEnquirer subform which relates to the current project. However, I also
want to be able to re-use the details entered on another occasion if the
same person becomes an enquirer against another project.

So, on the frmProjectEnquirer...
If I set the EnquirerID field to be a text box or a combo box, then when I
try to add a new customer, I receive an error message informing me that I
tried to assign a null value to a variable that is not a variant data type.

Do I need to create the enquirer outside of the main form and then return to
the frmProject to select the enquirer?

Any suggestions would be really most welcome as I feel like screaming at the
moment!

Regards
Colin Foster

 

[John Vinson]

Do I need to create the enquirer outside of the main form and then return to
the frmProject to select the enquirer?

Yes, or else you'll need to add a new record in VBA code.

However, you can do this from the enquirer combo box's NotInLiet
event. See

http://www.mvps.org/access/forms/frm0015.htm

for sample code.

 

[Colin Foster]

John,
Thanks. I think that it will be easier to create a button to open the
subform outside of th emain form so that I can then input all of the
information for this customer and then close it, returning to the main form
and requerying the combo box.
What a faff! This has kept me merrily entertained for the last couple of
days when I could have been doing much more fun things than locking horns
with Access!!
Once again, Thanks
Regards
Colin Foster