Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number of forms to create

Status
Not open for further replies.
dvannoy

dvannoy

MIS
May 4, 2001
2,765
US
We have about 8 customer service reps...each rep has a different status in the database.. should there be a form for each rep thats equal to his/her status? or what would be the easy/best way to do something like that?

Thanks
 
Sort by date Sort by votes
If I understand you correctly, the best way would be to use one form. Then in the on open property create an express and use the .visible property to hide and show fields based on the reps status.

Me.Status.Visible = False

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kingz2000
  • Locked
  • Question
Bound/unbound forms
Replies
2
Views
403
dhookom
dhookom
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
483
TomSalvato
TomSalvato
I
  • Question
How to get 2 codes to work together.
Replies
6
Views
217
hermanlaksko
hermanlaksko
TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
273
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
515
PrimoSteve
PrimoSteve

Part and Inventory Search

Sponsor

Back
Top