Protecting fields on a Form and Auto-populating Fields on a Form 
Author Message
 Protecting fields on a Form and Auto-populating Fields on a Form

Can someone please tell me how to do this? Thank you.

I have a form:

EmployeeID    ______    (Combo box to Employee Table)    Last Name_______
First Name _______
CourseID        ______    (Combo Box to Courses Query)     Course
Description _________________
SkillCode        ______
Skill Description     _________________

The Course Query has the following data:

CourseID
CourseDescription
SkillCode
Skill Description
Employee ID
Last Name
First Name

The user enters the EmployeeID by typing the number or the user slects an
employeeID from the combo box.
Result:  The Last and First Names automaticaly populate from the Employee
Table. The Last and First name fields do not allow the user to change the
data.  They are protected.

The user enters a CourseID or chooses one from the Course Query combobox.
Result:  The CourseDescription, SkillCode, and SkillDescription populate the
appropriate fields on the form and do not allow the user to change the data.
They are protected.

I need help on how to achieve the results above of:
1.  Populating theLast Name, FirstName, CourseID, CourseDescription,
SkillCode, Skill Description a
2.  Protecting these fields as well.



Sat, 04 Sep 2004 04:33:40 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Auto populate form field from previous value in field

2. !Populate some fields on a form with fields of another form

3. Auto-populate fields in form based on combo box selection

4. Need Login To Auto Populate Userid Field on Form

5. Auto Populate Field from form.

6. Auto-Populating Fields Based on Form Entries

7. Open a form with some fields auto populated

8. Auto-populate field on form

9. Auto populating fields in an Access form

10. auto populating fields in forms


 
Powered by phpBB® Forum Software © phpBB Group