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 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.
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.
For example: THe user enters house number and address. They then click a button which queries a database. The SQL query will have city, state, zip, year built, dwelling type etc. These values will be used to populate a few textboxes in the form.
I think the best way to do this is a simple VBA SQL query from the on click event of the button.but I am having problems with how to take the return SQL string and write them to varaibles to place in the textboxes.
Any thoughts? Am I thinking of this the correct way or is there another way to do this
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.
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
For this, I have created a sql query using simply SQL query wizard and got a sql query "SELECT Table1.entry1, Table1.entry2, Table1.entry3 Table1.entry4 FROM Table1;".
but I want to populate only the entries that matches Table1.entry1 = Field1 (of Form) and Table1.entry2 = Field2 (of form). I'm sure that I need to use the where clause for this.
But I dont know how to retrieve the form values inside a sql query. Please let me know whether m going in the right direction or is there any other way to do this
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.