I
ittnb2
Hi All,
I have used Access for a while for queries and tables, but I am trying to
expand and complete a project with forms and combo boxes.
Here is the scenario: Form 1 was created in design view with four combo
boxes each with a different row source. I want to make a selection from each
combo box and append to them all to one record in tblTemp1. When I try to do
this, it saves nowhere.
Ultimate goal is Form 1 save to tblTemp1, Form 2 will do similiar and append
to tbltemp2, Form 3 similiar and append to tlbtemp3. tbltemp1, tbltemp2,
tbltemp3 will generate a report with all of the information to print, and
write it all to one record in a history file. Then, the data in tbltemp1
tbltemp2 and tbltemp3 will be deleted.
I have the forms and tables created; if I fill in values in the tbltemp1 2
and 3, I can generate my report. My problem is getting the combo box data to
save correctly to the tbltemp1 2 and 3. When I try to set a control source
in the combo box properties, I get a "combo box control can't be edited,
bound to unknown"error. If I understand access correctly, I must save the
data to a table, because if I leave it in the form and close the form, I will
lose it.
Any and all help would be appreciated!!
ittnb2
I have used Access for a while for queries and tables, but I am trying to
expand and complete a project with forms and combo boxes.
Here is the scenario: Form 1 was created in design view with four combo
boxes each with a different row source. I want to make a selection from each
combo box and append to them all to one record in tblTemp1. When I try to do
this, it saves nowhere.
Ultimate goal is Form 1 save to tblTemp1, Form 2 will do similiar and append
to tbltemp2, Form 3 similiar and append to tlbtemp3. tbltemp1, tbltemp2,
tbltemp3 will generate a report with all of the information to print, and
write it all to one record in a history file. Then, the data in tbltemp1
tbltemp2 and tbltemp3 will be deleted.
I have the forms and tables created; if I fill in values in the tbltemp1 2
and 3, I can generate my report. My problem is getting the combo box data to
save correctly to the tbltemp1 2 and 3. When I try to set a control source
in the combo box properties, I get a "combo box control can't be edited,
bound to unknown"error. If I understand access correctly, I must save the
data to a table, because if I leave it in the form and close the form, I will
lose it.
Any and all help would be appreciated!!
ittnb2