I have a main form with a subform within a subform.
Form C is within Form B and Form B is within Form A
Form B is based on a record source that I set using VBA when the user selects certain drop downs and hits search on Form A. Form B has 2 Seperate keys that make it unique (recordnum and ID).
Within Form B my query returns both but only displays recordnum.
Within Form B i have a notes button that allows the users to add a note to this specific record. My problem is that if this record doesn't have a row in the notes table I have to add this row. I don't want to hit the database two times to do this. Once to check to see if a row with the id exists and one to instert a new row.
Is there a different way?
Is there a way to get ID without binding it to a hidden text field so I can use it for my insert into the notes table?
The Form Notes recordsource is "select Notes from tblNotes" I was planning to use the where condition from the openform function using RecordNum.
Sorry if this is confusing. I'm trying to make sure I have my app laid out as clean as possible.
Thank You for any help
Form C is within Form B and Form B is within Form A
Form B is based on a record source that I set using VBA when the user selects certain drop downs and hits search on Form A. Form B has 2 Seperate keys that make it unique (recordnum and ID).
Within Form B my query returns both but only displays recordnum.
Within Form B i have a notes button that allows the users to add a note to this specific record. My problem is that if this record doesn't have a row in the notes table I have to add this row. I don't want to hit the database two times to do this. Once to check to see if a row with the id exists and one to instert a new row.
Is there a different way?
Is there a way to get ID without binding it to a hidden text field so I can use it for my insert into the notes table?
The Form Notes recordsource is "select Notes from tblNotes" I was planning to use the where condition from the openform function using RecordNum.
Sorry if this is confusing. I'm trying to make sure I have my app laid out as clean as possible.
Thank You for any help
