A continues form and bound combo box issue

[Abdullatif]

1)The attached file database.txt is actually an access 2016 .accdb file and only needs to change the extension from .txt to .accdb.
2) the issue is:
The attached continues form includes two combo box fields (charge type and charge category). The second combo box value depends on the requery of the afterupdate property of the first combo (charge type). But when a new value is selected on the first combo (charge type) box the previous rows get deleted on (charge category).

 

[Uncle Gizmo]

But when a new value is selected on the first combo (charge type) box the previous rows get deleted on (charge category).

I usually tackle this problem with a pop-up form. See attached..

Here's a very nice example of the technique which I did in answer to another question a couple of a couple of years ago.

12) - Checklist With Multiple Choice - Nifty Access

 

[Uncle Gizmo]

Please note the poster has effectively made a double post...

One HERE:-

A continues form and bound combo box issue

1)The attached file database.txt is actually an access 2016 .accdb file and only needs to change the extension from .txt to .accdb. 2) the issue is: The attached continues form includes two combo box fields (charge type and charge category). The second combo box value depends on the requery...

www.access-programmers.co.uk

And the other HERE:-

Problem in continues form combo box

1) Change the .txt extension to .accdb for file fatabase7.txt. 2) The attached show.png file explains the issue.

www.access-programmers.co.uk

 

[MajP]

Update

 

[Abdullatif]

Hi all,

Thank you for your messages and the posted replies. I think I have come with a workaround which I believe solved my issue.
1- Rename the file database7.txt to database.accdb
2- Display the form frmHospitalCharge.

I guess Microsoft should be notified about this issue.

Thank you all for your replies.