Link to home
Start Free TrialLog in
Avatar of johnt_83
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!frmMarimba!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!
Avatar of GRayL
GRayL
Flag of Canada image

Post the query behind the combobox.
ASKER CERTIFIED SOLUTION
Avatar of wertyk
wertyk
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Forced accept.

Computer101
EE Admin