Re: Query run and displayed in a form?
- From: Benny Andersen <a.mail.user@xxxxxxxxx>
- Date: Wed, 31 Oct 2007 21:56:46 +0100
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 <subform>.requery method should
be invoked.
--
Regards
Benny Andersen
.
- References:
- Query run and displayed in a form?
- From: Tobias
- Query run and displayed in a form?
- Prev by Date: Re: Can't use SendMessage...WM_PASTE with a regular Text Box
- Next by Date: Re: 2003 Runtime and Full version on same machine?
- Previous by thread: Query run and displayed in a form?
- Next by thread: How to keep one form on top in A97?
- Index(es):
Relevant Pages
|
