Help Combobox problem

[Alhakeem1977]

I am still waiting for a solution to below post:

https://access-programmers.co.uk/forums/showthread.php?p=1622910#post1622910


Your prompt response would be highly appreciated.

 

[theDBguy]

I am still waiting for a solution to below post:

https://access-programmers.co.uk/forums/showthread.php?p=1622910#post1622910


Your prompt response would be highly appreciated.

Hi. I downloaded your file but it doesn't make sense to me. I am getting an error message or a warning everytime I select a department and then try to save the record. Can you give us a step-by-step instruction on how to duplicate your issue? Thanks.

 

[Alhakeem1977]

Hi. I downloaded your file but it doesn't make sense to me. I am getting an error message or a warning everytime I select a department and then try to save the record. Can you give us a step-by-step instruction on how to duplicate your issue? Thanks.

Could you check the below attached?

You will not get this error again.

 

[theDBguy]

Could you check the below attached?

You will not get this error again.

Hi. Are you sure? I downloaded it, but still got the following error and can't move forward.

After I click OK, the Department combo becomes blank.

 

[JHB]

I haven't read the whole thread but I think it is because the form's "Data Entry" format is set to "Yes".
Else show by screensdump what problem you've, because you call some of the comboboxes by name that doesn't exist so ....

 

[Alhakeem1977]

I haven't read the whole thread but I think it is because the form's "Data Entry" format is set to "Yes".
Else show by screensdump what problem you've, because you call some of the comboboxes by name that doesn't exist so ....

Yes, it's a data entry form and it supposes to be like that.

 

[JHB]

As theDBguy wrote, Can you give us a step-by-step instruction on how to duplicate your issue? Thanks.

 

[Alhakeem1977]

Hi. Are you sure? I downloaded it, but still got the following error and can't move forward.

After I click OK, the Department combo becomes blank.

I am so sorry to bother you with my problem.
Kindly check it now.

 

[theDBguy]

I am so sorry to bother you with my problem.
Kindly check it now.

Hi. Not sure if I should since you still haven't told us what to do with it.

 

[Alhakeem1977]

Hi. Not sure if I should since you still haven't told us what to do with it.

Hellow, try to save two records or more by choosing deferent departments and go previous and next then you will see that the ( Sent to ) disappear but in the table ( tblDeptReg) will not be affected.

 

[theDBguy]

Hellow, try to save two records or more by choosing deferent departments and go previous and next then you will see that the ( Sent to ) disappear but in the table ( tblDeptReg) will not be affected.

Okay, thanks. It worked this time without errors. So, the reason why you don't see anything in the Sent To dropdown is because your Row Source for it has a criteria, as shown below.

To fix it, you'll need to requery the combo in the form's current event. Check out the attached modified version of your db. Hope it helps...

 

[Alhakeem1977]

Okay, thanks. It worked this time without errors. So, the reason why you don't see anything in the Sent To dropdown is because your Row Source for it has a criteria, as shown below.

To fix it, you'll need to requery the combo in the form's current event. Check out the attached modified version of your db. Hope it helps...

Thank you so much it's working

 

[theDBguy]

Thank you so much it's working

Hi. You’re welcome. Glad we could assist. Good luck with your project.