Adding a query or table to field list to use as control source

F

FLBill0420

I have a form that I created using the wizard. I now want to add controls
that are I did not include when I originally designed the form. How do I do
this?

I need to add text boxes that contain information from newly created
queries. I know I can redo the entire form, but there must be an easier way.

Thanks in advance for your help.
 
J

John Vinson

I have a form that I created using the wizard. I now want to add controls
that are I did not include when I originally designed the form. How do I do
this?

I need to add text boxes that contain information from newly created
queries. I know I can redo the entire form, but there must be an easier way.

Thanks in advance for your help.
Click to expand...

Open the Form in design view; view its Properties; select the ... icon
by the Recordsource property.

Make sure that the desired fields are included in the Query.

You say "newly created queries" but of course we don't know what those
queries are or how they are related to the form's Query, so it's a bit
hard to help (see previous response).

John W. Vinson[MVP]
 
F

FLBill0420

Thanks for your reply. I created the queries after I created the form. The
fields are in the new queries. The new queries are not related to any of the
queries that are now in the form. For instance. I created a query that
lists all of the billing adjustments from the payments table and another
query that lists all of the refunds from the payment table, and another query
that lists the cash and charge payments. I want to add the refunds and
billing adjustments to the invoice form. Prior to creating the queries I
just had text box that contained all of the payments regardless of type.

Thanks.
 
J

John Vinson

Thanks for your reply. I created the queries after I created the form. The
fields are in the new queries. The new queries are not related to any of the
queries that are now in the form. For instance. I created a query that
lists all of the billing adjustments from the payments table and another
query that lists all of the refunds from the payment table, and another query
that lists the cash and charge payments. I want to add the refunds and
billing adjustments to the invoice form. Prior to creating the queries I
just had text box that contained all of the payments regardless of type.
Click to expand...

<shrug>

Still no information about the structure of your tables. Sorry, I
can't help, other than to say that you can't just add a slew of
queries to a Form. Perhaps a Form with several Subforms (one based on
the Adjustments query, another on the Refunds query, etc.) would be
better.

John W. Vinson[MVP]
 
Top