I have a pretty big form for data entry. On it is a subform for displaying data, which is always populated. This subform is attached to a temp make-table query.
Main form also contains a listbox for displaying data, but depending on what the user has chosen previously, this isn't necessarily enabled/populated. This listbox is attached to another make table query.
Problem I'm having is with my append query for collating all the data at the end.
The subform details come from it's temporary table, and the append query catches this data fine. Main form details go into another temp table that the append query catches fine also.
On the occasions the listbox isn't actually used, because the temp table for it is blank, the append query records no data at all. Not even for the subform or main form.
Because of this I abandoned the idea of using a temp table for the listbox, and tried capturing it's data in the append query itself, using a nested query, but I've a feeling this isn't possible.
If anyone can decipher the sql code below, could you tell me how I can nest the select query for the listbox data (at the bottom) inside the append query for the form?
Hope you can follow this.
People_Details_Trans - temp table for subform
Transactions_details - temp table for main form
transactions - table I need to collate all the data into
[Event Type], [Venue Location], [Initiated_By], [Action_Date] - details I need to insert into table transactions.