Unanswered: Unbound combo box used in append query
I want to append one record and populate selected fields with the result of combo boxes on a form. 1 combo box selection to "job number" field, and a second combo box to "task" field.
Maybe I am going about this the wrong way using an append query? Executing this query results in "you are about to append 0 rows...etc."
Field: job number
Append to: job number
Append to: task
but if you are ONLY adding these 2 items, then remove the table from the query and
put the form items in the field names:
Thanks for your help. That was successful, however I now realize that I need to populate a few other fields as well with data from 2 other tables. How would I add data from the other tables in the same record? I tried and failed to get a correct result, adding the other tables and fields like normal.
Yes, there would be 3 tables involved. the table I am appending [tblTasks], the main data table [tblData], and the specific task lookup table [tblTaskLookup].
My goal is to have a form with 2 combo boxes, one for the job number from [tblData] and another from [tblTaskLookup] for the specific task to be added to [tblTasks].
There are other fields in [tblTaskLookup] that will need to populate like fields in [tblTasks]. The result I am looking for is to add 1 record containing the job number and the specific task
selected on a form, with other fields in that record populated with information from the 2 other tables.
check column width of the combobox. if you're selecting the elements of the combox from a table or a query, you should also check column widths in property sheet.
In your case, you want to append the appearing data on combobox to a table. so, col widths shold be set to 1.