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:

Similar posts...

 

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

how do i populate the value of a field in query into a txtfield into another form Icon
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.
 

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

Trying to populate a text box on form with the result of a query Icon
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.
 

populate textboxes from listbox selection

populate textboxes from listbox selection Icon
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.
 

Find duplicates query to populate input form

Find duplicates query to populate input form Icon
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
 

Populating an array using a query

Populating an array using a query Icon
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.

Trying to populate a total from crosstab query into a form. Icon
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.
 

Displaying Query Results in a Form List Box

Displaying Query Results in a Form List Box Icon
I have a form that is linked to a query (and vice versa).

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.
 

query column not populating text box.

query column not populating text box. Icon
I have a query that is used to populate some fields in a form. the query has 9 columns: 0,1,2,3,4,5,6,7,8.
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:
 

Use some query results and a table to populate a second table

Use some query results and a table to populate a second table Icon
I have a query which goes through my customer and attributes them scores based on various conditions. Somebody will go through this list weekly or more often and attribute customers to case managers based on this score and a few other informations present in the query (location, last interaction date, etc.).

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.
 

Populate a form based on a query using parameters

Populate a form based on a query using parameters Icon
I have created a form that is populated from a query. I have a text box set up as an input box and click a button (Search) to execute the search. This appears to be working fine as the query opens and runs. However, it displays in the query in data format instead of in the Form I created. not the actual query. The Search button is set to RunQuery.