| | |
|
|
|
Getting a value from a table to display on a form??? |
|---|
| message from Peter Taylor on 9 May 2004 |
I have a form called frm_bookings and on it is a subform called
frm_sub_clients.
I have 2 tables called bookings and clients (each form associated with each
table).
I am trying to display the value of "fees" (which is in the clients table)
on the frm_bookings form, but as I am a relative novice at access I'm unsure
how. I've tried putting the following code into the frm_bookings form load
: Check89.Value = check19.Value but as check19 is on the subform it comes
back with the error Object required.
Anybody know how to do it? Surely there must be a simple way.
link to screenshot : http://petertaylor111.netfirms.com/a.jpg
any help much appreciated
TIA.
-pete
|
| Marshall Barton replied to Peter Taylor on 09 May 2004 |
Me.Check89= Me.subformcontrol.Form.Check19
|
| Peter Taylor replied to Marshall Barton on 9 May 2004 |
Sorry if I sound thick, but what should subformcontrol be?
I'm guessing it should be replaced with the value of something
(like I've done here : Me.Check89=
Me.subformcontrol.frm_sub_clients.Check19)
Thanks for the reply
-pete
"Marshall Barton" <marshbarton@wowway.com> wrote in message
news:i82t9015291oprdqjdbabu7k2qvilab8ih@4ax.com...
|
| Peter Taylor replied to Peter Taylor on 10 May 2004 |
Sorted it now, I ended up with
Me.Check89 = Me.frm_clients_sub.Form.check19
Thanks
-pete
"Peter Taylor" <peter_neal_taylor@NOSPAMtiscali.co.uk> wrote in message
news:409e8d8e_2@mk-nntp-2.news.uk.tiscali.com...
|
|
Archived message: Getting a value from a table to display on a form??? (Microsoft Access)
