By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,935 Members | 1,380 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,935 IT Pros & Developers. It's quick & easy.

Form with info check from other tables

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.