Link to home
Start Free TrialLog in
Avatar of Jass Saini
Jass Saini

asked on

My form is still not updating and if I do an unbound box then I get repeats

Hello

I have a DB..I have my query hardcoded.  From the query I am dumping into a form and the form is not updateable.  If I get rid of the DISTINCT then I get multiple records (Same).  Also I can update the blanks fields I have for user input...Still new at this. I inherited a DB..
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

try setting the Form's RecordsetType property  to Dynaset (Inconsistent Updates).

also see this When can I update data from a query

for possible causes and solution
Avatar of Jass Saini
Jass Saini

ASKER

Ok..I tried that and no luck.  But I will definitely check out the link.  I have been stuck for a whole month and I can't figure out why.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
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
Thank you...