Create Pull Down menu & open form with selection (1 Viewer)

[felicia.scott@]

I am wanting to do 2 things with my database (in the field control, I have no SQL exp)...

1. I want to create a pull down menu that allows the name of the small team employee to be selected that opens to a form that allows comments to be created for that same person for the Month YY I choose.

2. I want to be able to have a second form that allows me to see the records for an employee selected from the pull down menu that shows their Survey, TAT & audit data

FYI - I'm a novice being asked to stretch my skillset...

Any suggestions, laymens assistance is greatly appreciated.

 

[Ranman256]

The form is a singe record form of employee. All records in the query but shows 1 record at a time.

The combo box would also have all employees in it. (With EmpID hidden)
EmpID, EmpName

When you pick the person, it filters the form to the Id chosen,

Sub cboBox_afterupdate()
If IsNull(cboBox) then
   Me.filterOn= false
Else
    Me.Filter= "[EmpId]=" & me.cboBox
    Me.filterOn= true
End if

End sub

The form has a subForm bound to the ID,so you can enter data about the current employee.

 

[arnelgp]

there are many issues in your db.
did you import the data from another program, ie. excel?
avoid having space on your field names.
add another field on the rest of your table (SmallTeamID - long integer).
this will be your foreign key.
the primary key (on table [small team] is [small team id], again avoid the space).

once you have done that it is straight forward to link all your tables together.
and you can use just 1 form to show all info at a glance.

 

[felicia.scott@]

Thankyou to you both.

I will make the corrections to the database and will try the suggestions for the form and combo box.

 

[felicia.scott@]

Arnelgp,

Are you telling me to add a field SmallTeamID to all of the tables?

 

[arnelgp]

Its late here, tomorrow I'll give a sample based on your db.