Form with info check from other tables

[Rupert Street]

Hi
I have a form for staff to enter their work details into the Timesheet
table that I have setup. I have included a combo box to select a
client's ProjectNo from the Projects table selecting only the current
projects.

I then wanted to have the Sitename (Projects table) and the ClientName
(Clients table) shown on the form as a check that they have the
correct ProjectNo. These 2 fields are only checks and are not entered
into the Timesheet table.

Could someone give me some hints as to how I should do this please.

[Rick Brandt]

"Rupert Street" <ja**********@yahoo.com.au> wrote in message
news:3a**************************@posting.google.c om...

Hi
I have a form for staff to enter their work details into the Timesheet
table that I have setup. I have included a combo box to select a
client's ProjectNo from the Projects table selecting only the current
projects.

I then wanted to have the Sitename (Projects table) and the ClientName
(Clients table) shown on the form as a check that they have the
correct ProjectNo. These 2 fields are only checks and are not entered
into the Timesheet table.

Could someone give me some hints as to how I should do this please.

Include them in your ComboBox's RowSource as hidden columns. Then put two
TextBoxes on your form with ControlSource entries of...

=ProjectNo.Column(1)
and
=ProjectNo.Column(2)

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com