Topics Search

Populate Form using a Query

Populate Form using a Query
Views: 11
I have a table named "Event". I have records in the table that I want to populate the rest of the forms unbound text fields based upon the selection of the combo box "event name" and combo box "event date".

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.
Sponsored Links:

More topics

 

how do i populate the value of a field in query into a txtfield into another form

Preview
I have an Access 2010 Form that opens a query through OnLoad. While both forms and query are open, I want to populate a field from query into a txtfield on Form. How can I achieve this. a practical example of code through a click on command button would explain it to me better.
 

populate textboxes from listbox selection

Preview
I am trying to populate textboxes on my form when I make a selection from my listbox.

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.
 

SQL query, populate form input boxes

Preview
I am trying to find the easiest way to populate some input boxes on my form based off of two other fields.
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
 

Trying to populate a text box on form with the result of a query

Preview
This is my situation.

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.
 

Find duplicates query to populate input form

Preview
I have a ClientTable that contains client contact information, which has been uploaded from all sales reps for the purpose of making individual sales calls. What I need is a MainForm for the caller to select a specific RepName from a drop down list and have it populate the results into an InputForm, which will need to be editable 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
 

Find duplicates query to populate input form

Preview
I have a ClientTable that contains client contact information, which has been uploaded from all sales reps for the purpose of making individual sales calls. What I need is a MainForm for thecaller to select a specific RepName from a drop down list and have it populate the results into an InputForm, which will need to be editable 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.
 

Populate table entries when clicked on form button

Preview
I have a MS access 2007 form with two fields say Field1 and Field2 and a button. When button is pressed I want to populate all the entries matching Field1 and Field2 in datasheet view from table Table1.

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
 

Populating an array using a query

Preview
I am trying to populate an array using info from a query. The query looks at a specific date, entered on a form by the user, then looks for the number of orders entered by each employee on that date.

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?
 

Trying to populate a total from crosstab query into a form.

Preview
I have a crosstab query that has a total for that particular inbox(Registered) and I'm trying to create a form that will populate the total. I went into the control source and did the pathto the crosstab query (Total) and it is giving me "#Name?" error.
 

Populate TextBox using ListBoxe from another form

Preview
I am using a ListBox(Combo12) which contains values of ETO from a query[ID-ETO].
I have selected the ETO field from the table [List] to populate my ListBox.
The combo12 is on form named [MainForm].
Now, I have another form [Form_1] which has several textboxes including the ETO, etc. all of which are contained in a table [List].
So How do I use a button on MainFrom to select a particular ETO to open Form_1 to populate different textboxes?
Can someone tell me which events in the property sheet of the corresponding forms, buttons and combo boxes need to be used to trigger this event. I am really confused here and have been stuck