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

  • Thread starter Thread starter Peter Taylor
  • Start date Start date
P

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
 
Peter said:
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.
Click to expand...


Me.Check89= Me.subformcontrol.Form.Check19
 
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
 
Sorted it now, I ended up with
Me.Check89 = Me.frm_clients_sub.Form.check19

Thanks

-pete
Peter Taylor said:
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
Click to expand...
 
Back
Top