I'm not doing form/subform because it's all on one table. If I had used two different tables, the form/subform would be an easier route. I'm not familiar with being able to do form/subform on the same record. Is it something that can be done?
I'm not doing form/subform because it's all on one table. If I had used two different tables, the form/subform would be an easier route. I'm not familiar with being able to do form/subform on the same record. Is it something that can be done?
If I were to change the OnCurrent to Me.EmployeeID=Me.cboEmployeeID, then when I do a search the combos will be blank and the fields will change to null.
What search? Sounds like you have more going on other than a simple data entry form.
Can you give us more info?
What are the fields in your tables?
What other code do you have in the form?
Whats the workflow?
Post a sample db if you can.
I'm still unsure of your specific requirement but perhaps you need to test for new record and have your code respond accordingly.
Something along the lines of ...
Code:If Not Me.NewRecord Then Me.cboSupervisorID = Me.SupervisorID Else Me.SupervisorID.DefaultValue = Me.cboSupervisorID End If
Yes. This has a lot going on all over the place. I had a different form that I used for searches. I was hoping to eliminate that form and just use this one. Since I really have to move onto a different part of my database, I'm going to leave that form in place. Maybe I'll revisit it later. Thanks to all.