Populate Form using a Query
The table fields are:"Event Name", "Event Date","Call for Service", "POC Name", "POC Phone 1", "POC Phone 2", "Event Instructions"
The unbound form field names are:"QEvent Name", "QEvent Date", "QCall for Service", "QPOC Name", "QPOC Phone 1", "QPOC Phone 2", "QEvent Instructions"
POC means Point of Contact.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I would like for the result(count of records) of a query to populate automatically when you open the form in a unbound text box with out pushing the command button to actually get theresult(with details instead of just a count that I'm looking for).
also the query has different criteria therefore I need the result of the whole query not just a particular column in the query.
I populated the listbox with a query and this works as it should.
The query loads two columns in the listbox. One is an id (FDID) and the other is the persons last name.
I tried using the control source of the textboxes to get the info from the listbox, but it will only populate 2 out of the 5 textboxes. The ones that populate, of course, are the FDID and last name.
How do I get the rest of the values from the table?
I did a search, but nothing I found fits my needs.
What I believe I need is a find duplicates query based on the rep name chosen, but also have it populate into the input form and be editable back to the original table
I want to display the results on the screen and also be able to print it if needed by the user. Usually there are between 2 and 4 order entry people. I understand some about arrays and how they work but I can't figure out how to populate them from a query.
Or would I be better off using list/combo boxes?
I want to display the results of the query in the form.
I have lists boxes on the form, but when I use a button to launch the query, it does exactly what I don't want . launches the query.
I just want the query results to populate the List Boxes that I have linked to the fields in the query.
when I update a combo box (field 0) the query should populate the rest of the text boxes using columns 1-8.
the problem: column 8 is not populating.
every other text box is filled. For the text box control source, I have used =[query name].[column](#) where # is the column number respectively.
so for the text box =[query name].[column](8) it does not show anything (if I run the query, all data is there)
if in that same text box I put =[query name].[column](1) then it does show something, basically, all of them show except column 8.
below is my sql for the query:
I have a table which lists the case managers so we can use it to populate a List box.
I need to take the information from my query and pair the customer number to the case managers using a form or something, in datasheet view/format. When I try to use the form wizard, it doesn't want to do that.
Says that it can't find the link between the query and the table. I have created an empty table with three fields: ID(PK), Customer_number, Case Manager. I want this table to hold the pairing data once the customers are attributed to a case manager.
However, some customers will not have a case manager, so I don't want to populate this table with superfluous information if I can avoid it.
After all, we're talking about 30k customers, of which about 10% (at the most) will end up having a case manager.
So. how do I do that? I'm sure it's pretty basic, but I can't see my way out of this conundrum.