johnt_83
asked on
How do I replace the information in a datatable with different selections from a combo box?
Microsoft Access - SQL
I've got the code right, as anytime a user selects a UID or NAME from each combo box the datatable fills that information based on that person's UID or NAME, however, how do I make it so that the datatable continuously replaces the newly selected information rather than keeping the previous information there?
Imagine this showing up on a data table...you select UID = 1 and Jason and his information shows up, but then you select NAME = Maria, her info shows up, but Jason's remains...I only want one of them showing up everytime I select it from the combo box...
My code:
SELECT eDiscovery.NAME, eDiscovery.CASE FROM eDiscovery WHERE (((eDiscovery.UID)=Forms!f rmMarimba! cmbUID)) Or (((eDiscovery.NAME)=Forms! frmMarimba !cmbNAME)) ;
This is in the Row Source code space for the form (frmMarimba). How can I make it so only one row of data appears everytime I select something different from the combo box? Thanks!
I've got the code right, as anytime a user selects a UID or NAME from each combo box the datatable fills that information based on that person's UID or NAME, however, how do I make it so that the datatable continuously replaces the newly selected information rather than keeping the previous information there?
Imagine this showing up on a data table...you select UID = 1 and Jason and his information shows up, but then you select NAME = Maria, her info shows up, but Jason's remains...I only want one of them showing up everytime I select it from the combo box...
My code:
SELECT eDiscovery.NAME, eDiscovery.CASE FROM eDiscovery WHERE (((eDiscovery.UID)=Forms!f
This is in the Row Source code space for the form (frmMarimba). How can I make it so only one row of data appears everytime I select something different from the combo box? Thanks!
Post the query behind the combobox.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin