Urgent enquiry - need help with cascading combos

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Quick explanation:

I have designed an employee database. My supervisor says team leaders will
complain if they have to fill out employee information as well as the hours.
Her suggestion is to use a combo box, select the employee from a list which
can then populate other employee information. What I have done is set up a
link table in Excel that can be used to automatically update information in
the database.

I have also used a combo box for department and sub-department which also
works fine.

I have two problems:

1) The information from the drop boxes isn't being stored in the table.

2) When moving from one record to another, the information for the employee
doesn't change.

I suspect my referencing is wrong somewhere.

Cheers in advance
 
scubadiver said:
Quick explanation:

I have designed an employee database. My supervisor says team leaders will
complain if they have to fill out employee information as well as the
hours.
Her suggestion is to use a combo box, select the employee from a list
which
can then populate other employee information. What I have done is set up a
link table in Excel that can be used to automatically update information
in
the database.

I have also used a combo box for department and sub-department which also
works fine.

I have two problems:

1) The information from the drop boxes isn't being stored in the table.

2) When moving from one record to another, the information for the
employee
doesn't change.

I suspect my referencing is wrong somewhere.

Cheers in advance
Click to expand...

It looks like your combo box isn't bound to a field. As an aside, linked
tables to Excel will stop working if you get SP2 applied to MS Office, so
you might want to seek an alternative method before the inevitable happens.

Regards,
Keith.
www.keithwilby.com
 
How do I bind to a field. I'm not having much luck.

Not wishing to sound naive, what is "SP2"?
 
1. Open the form in design view.
2. Open the form proprties (Alt + Enter Or from the menu bar select View >
Properties
3. Select the combo by clicking on it
4. One of the properties called "ControlSource" put the cursor in it
5. Click on the right to get the name of the fields from the table that the
form is bounded to, select the right field where you want this data to be
stored
 
Hi,

I have had a look at this and it has worked for the text columns.

The drop down for the employee name populates four fields. Two of these
fields are pay rates and it hasn't added values to the table even though it
has done for the text fields.

These two fields are bound to the table like the rest so I can't see why it
hasn't happened.

The other strange thing I have is that the four boxes for these fields have
mysteriously turned black.

Any ideas?
 
Back
Top