C
Cat Winslow
I have looked for answers to this many times to no avail. Thanks in advance
for all help...
I have a main form built on a query containing Customer.* and System.* so I
can look up by any field in either of those tables. On one tab I have a
subform frmDatesAndServices (RecordSource is tblDatesAndServices) containing
dates of inspections for the systems we track. It is linked on
SystemID;CustomerID (a suggestion by an MVP that solved a previous issue). On
this form is a button I want to click to open an Inspection form, linked by
the same SystemID, and I want it to fill in the CustomerID from the current
record on the main form, SystemID and some other system info (SysLocation,
SysSize, SysColor...) from the main form, Service# and other info (ServDate,
ServTech...) from frmDatesAndServices. On frmDatesAndServices, Service#(PK)
is autonum, so I tab over that and enter the dates, then click the button to
open the Inspection form. I have tried so many variations, and the best I can
get is a form which DOES fill in the data but I get none of my default
values, until I type in any value and tab, then they all fill in, with my
Null yes/no fields all becoming No's.
Can someone sugget a rundown of my RecordSources that would work for this
setup? Or should I set up a whole list of me.SystemID =
Forms.frmCustomersSystems.SystemID (?correct) and assign all the values to
the new Inspection form?
I'm goin' crazy, don't ya wanna come along...
for all help...
I have a main form built on a query containing Customer.* and System.* so I
can look up by any field in either of those tables. On one tab I have a
subform frmDatesAndServices (RecordSource is tblDatesAndServices) containing
dates of inspections for the systems we track. It is linked on
SystemID;CustomerID (a suggestion by an MVP that solved a previous issue). On
this form is a button I want to click to open an Inspection form, linked by
the same SystemID, and I want it to fill in the CustomerID from the current
record on the main form, SystemID and some other system info (SysLocation,
SysSize, SysColor...) from the main form, Service# and other info (ServDate,
ServTech...) from frmDatesAndServices. On frmDatesAndServices, Service#(PK)
is autonum, so I tab over that and enter the dates, then click the button to
open the Inspection form. I have tried so many variations, and the best I can
get is a form which DOES fill in the data but I get none of my default
values, until I type in any value and tab, then they all fill in, with my
Null yes/no fields all becoming No's.
Can someone sugget a rundown of my RecordSources that would work for this
setup? Or should I set up a whole list of me.SystemID =
Forms.frmCustomersSystems.SystemID (?correct) and assign all the values to
the new Inspection form?
I'm goin' crazy, don't ya wanna come along...