Getting a value from a table to display on a form???

[Peter Taylor]

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]

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.

Me.Check89= Me.subformcontrol.Form.Check19

 

[Peter Taylor]

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

 

[Peter Taylor]

Sorted it now, I ended up with
Me.Check89 = Me.frm_clients_sub.Form.check19

Thanks

-pete

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