Add a field in query to a form (1 Viewer)

[Fandy]

Hi,
I am designing a form in my access database, I want to add some of the fields from a query
i have created to the form but don't know how to go about it. I need help. Can someone help
me out? Thank you

 

[jdraw]

Use your query as the recordsource of the form.

Tell us more about your database,form and query if that link isn't helpful.

 

[Ranman256]

edit the query, add the field,
then add the field to the form.

 

[Fandy]

I have created the query already as shown in the image. I want to show the "totalCommit" field in the membershipF form. I will be glad if you could direct me. Thank you.

 

[Eugene-LS]

I will be glad if you could direct me.

Here you are!
01. Open your form
02. On ribbon (left side end) click button "Design View"
03. On ribbon (right side) click button "Add Existing Fields" - Right panel with enviable fields will shown
04 Drag and drop needed fields from panel to form ...

 

[bob fitz]

View attachment 98800 have created the query already as shown in the image. I want to show the "totalCommit" field in the membershipF form. I will be glad if you could direct me. Thank you.

Is this query used as the Record Source for the membershipF form

 

[Fandy]

Here you are!
01. Open your form
02. On ribbon (left side end) click button "Design View"
03. On ribbon (right side) click button "Add Existing Fields" - Right panel with enviable fields will shown
04 Drag and drop needed fields from panel to form ...

I only see available tables. I cannot see any query there. I want to see the query too to select field from.

 

[bob fitz]

I only see available tables. I cannot see any query there. I want to see the query too to select field from.

I think it might be best, for you to post a copy of your db

 

[Eugene-LS]

I want to see the query too to select field from.

Fine ...
01. Open your form
02. On ribbon (left side end) click button "Design View" or Right click on form and in menu select "Design View"
03. When form in "Design View" - Right click on form and in menu select "Properties" - Panel "Property Sheet" will shown in right side of Access window.
04. In "Property Sheet" panel select "Data" tab
05. In "Property Sheet"- "Data" tab: Find please property "RecordSource"
06. In "Property Sheet"- "Data" tab - Property "Record Source": There will be ComboBox ("drop-down list") on the right
07. In Combo Box "Record Source" select your query
That's it!

 

[Fandy]

Is this query used as the Record Source for the membershipF form

No please but i want to show a field in the query on the membershipf form.
the Record Source for the membershipF form is membership table. Kindly help me please

 

[GPGeorge]

I only see available tables. I cannot see any query there. I want to see the query too to select field from.

We would get better information from seeing the actual accdb, for sure.

However, I think you might be heading down a dead end path here, so let's regroup a bit.

You have a form. That form ALREADY has a recordsource, which is either a table or a query. If that form is intended for data entry (add, update or delete records) then it should be a single table, or a query based on that table. Queries with multiple tables joined tend not to work well for data entry, although it is possible if you know what you're doing. So, on the face of it, wanting to ADD another query to the form is pushing in the direction of making it non-editable. Plus the fact that the requested field is called "Total Commit" is a red flag that this would, indeed, make the result non-editable. See Allan Browne's list of things that cause queries to be uneditable. Aggregate queries (those with "totals") are not editable and if you include it in this form's recordsource, it's now read-only. If that's the goal, no problem.

Depending on WHY you want that one field from a different query to be DISPLAYED on the same form, there is probably at least one reliable way to do that. So, the follow up. WHY do you need this one additional field? Will it be there for reference?

 

[Eugene-LS]

the Record Source for the membershipF form is membership table. Kindly help me please

In "Property Sheet"- "Data" tab - Property "Record Source": Change value of ComboBox from "membership" to "TotalCommitQ"

 

[GPGeorge]

Forgot the link to Allen Browne's page.

 

[Fandy]

Fine ...
01. Open your form
02. On ribbon (left side end) click button "Design View" or Right click on form and in menu select "Design View"
03. When form in "Design View" - Right click on form and in menu select "Properties" - Panel "Property Sheet" will shown in right side of Access window.
04. In "Property Sheet" panel select "Data" tab
05. In "Property Sheet"- "Data" tab: Find please property "RecordSource"
06. In "Property Sheet"- "Data" tab - Property "Record Source": There will be ComboBox ("drop-down list") on the right
07. In Combo Box "Record Source" select your query
That's it!

It works! Thank you.

 

[Fandy]

In "Property Sheet"- "Data" tab - Property "Record Source": Change value of ComboBox from "membership" to "TotalCommitQ"

It works. Thank you.