Need field to not refresh

[maxxximaniac]

Hey every1

in a form header I have a combo box to select an employee, when I go to the next record in the detail this combo box refreshes and clears... I need this combo box to keep the selection made and not refresh upon a next record

Any thoughts?
Thank you!

 

[Mile-O]

Why do you need it for the next record?

 

[maxxximaniac]

the employee is the one who would accept a payment from a customer... This would be for a prolonged period of time so I want the field to remain the same unless a different employee covers.

 

[Milothicus]

I think you'd need to use a main/subform set up instead of a header, because the header (as far as i understand) is connected to the form's current record like the rest of the form. a main/sub setup may allow you to move through records in the sub without changing the main...or you could use the defaul setting for the field, and change it when the employee changes.

just throwing out ideas....maybe it'll spark something.

 

[BLeslie88]

Easier yet...

Make this particular 'user / employee' unbound or assign the values from a query. Use a sperate control... Then assign this value as default in the recordset being updated. Easy solution...?

 

[maxxximaniac]

i made the combo box get values from a query and it still has the same effect. What do you mean by use a seperate control?

I cant make the combo box unbound because I need it to write to a table along with other fields in the form such as a loan number and an anount..

I dont want to make a certain record default because if someone else uses the DB then it will auto default to a different person...

there are about 10 users.

 

[maxxximaniac]

I think you'd need to use a main/subform set up instead of a header, because the header (as far as i understand) is connected to the form's current record like the rest of the form. a main/sub setup may allow you to move through records in the sub without changing the main...or you could use the defaul setting for the field, and change it when the employee changes.

just throwing out ideas....maybe it'll spark something.

i actually used your idea in another DB i made but i wanted to avoid that method and try to learn a differnt one.

 

[Milothicus]

what if you make a second combo (unbound) that determines the default for the original combo, which you can then hide?

 

[maxxximaniac]

That didn't work for me either...
Anyone have any other thoughts?

 

[maxxximaniac]

here is a link to the DB
the main form is frm_MainForm
if I could get any help I would appreciate it

Thanks again!

http://www.zaiderman.com/Payment Window Customers.zip

 

[Mile-O]

i actually used your idea in another DB i made but i wanted to avoid that method and try to learn a differnt one.

The subform is the appropriate method.