Two comboxes with move between records in data entry form in MS Access

[Alhakeem1977]

Hi everyone,

I have got a two comboxes (cboDept) employee department requery a (cboEmployee) employee in a data entry form.

The issue is when I finished my entry and try to see my records go previous I got the cboEmployee become blank.

How can I avoid the cboEmployee to become blank?

Thanks in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk

 

[theDBguy]

Is the combobox bound to the employee field?

 

[Alhakeem1977]

Is the combobox bound to the employee field?

Yes, it is.

 

[theDBguy]

Yes, it is.

Is there any code the form’s Current event?

 

[Alhakeem1977]

Is there any code the form’s Current event?

No, there isn't any code.

I guess because of the requery in the dept combobox, when I enter two records for an employees from the same department no problem but when I select an employee from another department then the previous records will empty the employee combobox.

I think maybe I have to unreqery when navigate between the records but I do not know how build a code to achieve this action.

Thank you so much for your prompt response.

Sent from my HUAWEI NXT-L29 using Tapatalk

 

[theDBguy]

No, there isn't any code.

I guess because of the requery in the dept combobox, when I enter two records for an employees from the same department no problem but when I select an employee from another department then the previous records will empty the employee combobox.

I think maybe I have to unreqery when navigate between the records but I do not know how build a code to achieve this action.

Thank you so much for your prompt response.

Sent from my HUAWEI NXT-L29 using Tapatalk

Hi. Can't say without seeing what you got. Are you able to post a demo version of your db with test data?

 

[Alhakeem1977]

Hi. Can't say without seeing what you got. Are you able to post a demo version of your db with test data?

Please find my db attached.

 

[theDBguy]

Please find my db attached.

Hi. Thanks. I see three forms. Which one should I looked at?

 

[Alhakeem1977]

Hi. Thanks. I see three forms. Which one should I looked at?

It's the startup form: frmDeptRegSender

 

[Alhakeem1977]

Hi. Thanks. I see three forms. Which one should I looked at?

Sorry by the way I am struggling :banghead: with to get the easiest way when I have an update to an existing front-end database and I want to distribute it to our users in the organization through a shared folder (Local network) it's very difficult for me to do it for every user's machine I really need it .

How can I automate this distribution of the front-end?

 

[theDBguy]

Sorry by the way I am struggling :banghead: with to get the easiest way when I have an update to an existing front-end database and I want to distribute it to our users in the organization through a shared folder (Local network) it's very difficult for me to do it for every user's machine I really need it .

How can I automate this distribution of the front-end?

Hi. This is a completely different question but you can easily manage it by using any of the available techniques/demos on "auto-FE updater" out there. I use a simple/straightforward method of utilizing a VBS script to copy the FE from a master location to the user's computer and then launches it, which means they always get the latest and most updated version of the FE.

 

[Alhakeem1977]

Hi. Thanks. I see three forms. Which one should I looked at?

Sorry, I did a mistake.

Please ignore the previous attachment and use this instead.

 

[Alhakeem1977]

Sorry, I did a mistake.

Please ignore the previous attachment and use this instead.

Any further suggestions are welcome ASAP.

Thanks a lot in advance!

 

[theDBguy]

Any further suggestions are welcome ASAP.

Thanks a lot in advance!

Just FYI, the discussion continued here.