Greetings Access Gurus,
I am sure this will be simple for many of you, but I am struggling and appreciate assistance.
End State Goal:
I want a report to be created based on the choice the user picks from the options of a combo box - choose the option, click a button and the formatted report is presented to the viewer.
What I have:
I have a table named "Assets" that is populated with several fields, the field I want the report to be based on is the "Network" field. I have set the field up a short text with the lookup display control being a Combo Box, the row source is a value list, in the row souce I have 'Choose';'Network 1';'Network 2';'Network 3' and so on.
I created a report that has all of the options I want to be displayed, it is called Network Type Report. I have an unbound combo box that has no control source selected, the row source is SELECT Assets_tbl.[Network] FROM Assets_tbl; and Row Source Type is Table/Query
I created a form that has an unbound combo box, there is nothing in the Control Source, in the Row Source I've put the same info as I did in the unbound combo box on the report SELECT Assets_tbl.[Network] FROM Assets_tbl; and Row Source Type is Table/Query
Under the form I have a button with the following VBA
Code:
Private Sub cmdOpenReport_Click()
DoCmd.OpenReport "Network Type Report", acViewReport
End Sub
When the form loads and I try to click the combo box I get the following error:
The record source '~sq_CSelect Network~sqcNetwork' specified on this form or report does not exist.
The name of the recordsource may be misspelled, the recordsource was deleted or renamed, or the recordsource exists in a different database.
In the Form or Report's Design view or Layout view, display the property sheet by clicking the Properties button, and then set the RecordSource property to an existing table or query.
I have no idea where it is finding this information nor do I now how to code it to get it to do what I want it to do.
Thank you so much for helping.