Hi All,

I have a form that has a control source leading from two tables, I've
done this by creating one parameter query that links the two tables.

I want to add another table to this parameter query so that I can
capture further information in a seperate table.

When I add in another table to the parameter query on the controlsource
of the form, it returns a totally blank form. All of the control
vanish...

Van T Dinh has advised on a previous post that "...If that the case, it
sounds like your Form is bound to a
RecordSource and the RecordSource does not have any row
returned. "

What does this mean? Also does anyone know a way around this?

I cannot think of another solution.

Many Thanks
Adam

What Van's suggesting is that adding the new parameter resulted in no rows
being found that matched the criteria.

Have you tried running the query outside of the form? Are any rows returned?


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"(E-Mail Removed)" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I have a form that has a control source leading from two tables, I've
> done this by creating one parameter query that links the two tables.
>
> I want to add another table to this parameter query so that I can
> capture further information in a seperate table.
>
> When I add in another table to the parameter query on the controlsource
> of the form, it returns a totally blank form. All of the control
> vanish...
>
> Van T Dinh has advised on a previous post that "...If that the case, it
> sounds like your Form is bound to a
> RecordSource and the RecordSource does not have any row
> returned. "
>
> What does this mean? Also does anyone know a way around this?
>
> I cannot think of another solution.
>
> Many Thanks
> Adam
>

Hi,

I've run it outside and no rows are returned. However I changed the
link between the tables to provide some rows of data. I try this in the
parameter query and still get a blank page.

Sorry, but if you want someone to help you solve the problem, you're going
to have to provide some details!

You can see your tables: we can't.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"(E-Mail Removed)" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I've run it outside and no rows are returned. However I changed the
> link between the tables to provide some rows of data. I try this in the
> parameter query and still get a blank page.
>