ComboBox to Populate Continuous Form

[Elwood07]

Hello!



I'm trying to populate a continuous form based on information in a combo box. I'll describe what I'm trying to accomplish:

This is for a property with multiple restaurant venues. Every night our night audit team needs to audit the total credit card amounts transacted on each credit card terminal in each outlet. At the end of the night, each CC terminal prints a report of total amount transacted by credit card type. The team needs to take that report and plug the data into a form for each outlet.
I want the user to be able to pull up a form in access, choose the venue from a combo box that will act a as filter so only the cc terminals assigned for that restaurant will populate. Then the user will select the date, and the continuous form will be further filtered. I've used left outer join on my table relationship so that all terminals will show by outlet even if there is no current data for that date selected for that venue, the list of terminals assigned to that venue will still populate.

Once the list is there, the user will simple go down the list of terminals and enter each amount by CC. The problem I'm having is that only the first record in the continuous form is applying the date to the record. The date and outlet are on the main form and the continuous form is a subform. the outlet is an unbound combo box, but the date is a bound text box. It seems this should be a simple solution...Maybe there's a better way to approach this. The key is that every terminal has to be listed for the outlet that is selected, for the user to enter the amount. all terminals may not be used every night, but the whole list needs to be populated. There are over 85 terminals that we're going to be dealing with and 15+ outlets. I'm trying to make this as easy as possible for our teams.

And ideally, the table can be pivoted so I have cc type going down and terminal # going across, to follow the same flow of the receipt that will be printed out, but that's secondary.

Any suggestions or ideas would be greatly appreciated!


Combobox: Restaurant A
Date: 12/10/15
__________________________________
Amex Chase Discover Visa
term 1
term 2
term 3
term 4
term 5
term 6

Thanks in advance!

[Micron]

choose the venue from a combo box
the outlet is an unbound combo box

Is the outlet and venue the same thing?
If so, why isn't the outlet combo bound to something? And do you have the parent/child relationships between the form and subform linked for date AND venue/outlet?
And, after user chooses the date and venue, are you requerying the subform?
Those could be why it's not working as expected.

An issue you may run into if you try to pivot the records is that the number of fields in a cross tab query can change with the number of groupings that will be created from the records. In other words, if the first time you run the query you end up with 10 fields, the next time you can end up with 7, so it can cause wonky results if you base any other queries off of a cross tab. You'd have to force all groups to be present each time (maybe by judicious use of joins) if you were to do that. Not sure that is your intent.