Hello all,
I'm currently putting together a database which links together Clients and Brokers, and have put together this small mock database to illustrate my issue. I currently have a form which allows End users to add New Clients to the system without meddling in my tables or queries, and to avoid any spelling errors or record duplicates, I have added a combo box which supplies the end user choices for the Broker ID. There is also another form which the users can go to to create new Brokers, and thus new Broker IDs. The problem I'm currently trying to fix is that if a user goes in to enter a new client and the Broker ID doesn't exist yet, and they proceed to open the other form to add the broker, the New Client form's combo box will not update without closing the form first.
Any help is greatly appreciated!
I'm currently putting together a database which links together Clients and Brokers, and have put together this small mock database to illustrate my issue. I currently have a form which allows End users to add New Clients to the system without meddling in my tables or queries, and to avoid any spelling errors or record duplicates, I have added a combo box which supplies the end user choices for the Broker ID. There is also another form which the users can go to to create new Brokers, and thus new Broker IDs. The problem I'm currently trying to fix is that if a user goes in to enter a new client and the Broker ID doesn't exist yet, and they proceed to open the other form to add the broker, the New Client form's combo box will not update without closing the form first.
Any help is greatly appreciated!
