Query run and displayed in a form?

Hello,

I have a data entry form. When data is entered in one of the fields I
would like that data to be used to lookup info in a query and have
that displayed in the form. The main form is a purchase form, when
the budget field is selected I would like a query run that looks at
that budget and returns the amount remaining. I currently have the
query working - I do not know how to "embedd" it in the form and
trigger the query when budget field is changed.

Where should I start? I am obviously not sure of the terminology.

Any advice on where to start would be much appreciated.

Thank you,
Tobias

Re: Query run and displayed in a form?

On Wed, 31 Oct 2007 18:02:22 -0000, Tobias wrote:

> Hello,
>
> I have a data entry form. When data is entered in one of the fields I
> would like that data to be used to lookup info in a query and have
> that displayed in the form. The main form is a purchase form, when
> the budget field is selected I would like a query run that looks at
> that budget and returns the amount remaining. I currently have the
> query working - I do not know how to "embedd" it in the form and
> trigger the query when budget field is changed.
>
> Where should I start? I am obviously not sure of the terminology.
>
> Any advice on where to start would be much appreciated.
>
> Thank you,
> Tobias

well, you can use a subform that shows the "working query". On the event of
after update of the field in main form, the .requery method should
be invoked.
--
Regards
Benny Andersen