Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

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..
0
Jass Saini
Asked:
Jass Saini
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
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
0
 
Jass SainiAuthor Commented:
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.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
From the query I am dumping into a form and the form is not updateable.
Your QUERY must be updateable in order for your Form to be updateable, and Query with a DISTINCT keyword will not be updateable.

In cases like this, you either need to (a) clean up the data so that you don't need to use DISTINCT or (b) create an unbound form and manage the data manipulation yourself.
0
 
Jass SainiAuthor Commented:
Thank you...
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now