tnjarrett
Last Activity: Oct 1 '09, 06:12 AM
Joined: Sep 22 '09
Location: Rome, Italy
-
Poor design, eh... OK - how would ensure that all the weights (entered by the user within the subform) of the individual species samples (Quantity) sum up to the Q-sample total in the 'Document' record? There could be anywhere from 5 to 30 species. Like I have said twice, the subform is a continuous form (like a datagrid). Do you understand the design now? Do you still consider this a 'poor' design?
Thank you for... -
Hello Linq,
Thank you for the suggestion. That is not a good option though.
In the subform, I present many records in a continuous form (simulating a datagrid). I want to do the validation when the subform is exited (after all the records are updated). If I use the Form_BeforeUpda te event, validation is done after every record is changed. How would I do the validation when the subform loses focus?
Maybe...Leave a comment:
-
Bummer#2
OK - I found out why the recordset was not editable - it was my query. I changed it to be:
...Code:Set rsLandSpecies = CurrentDb.OpenRecordset _ ("SELECT LandingSpecies.cd_Document, LandingSpecies.cd_Species, " _ & "Species.Description, LandingSpecies.Quantity, " _ & "LandingSpecies.Num_Indiv , LandingSpecies.Price, LandingSpecies.Value " _ &Leave a comment:
-
In subform, Recordsource=Query (updateable) while =Recordset(read-only)
Hello, I have a MS Access continuous subform that was using a query as the recordsource.
I changed it to use a recordset instead because when the query was used, the changes to the subform values directly changed the tables under the query. I wanted the changes to be 'in-memory' so that I could check them before applying them to the tables.
When I changed the subform to use the recordset, it is now 'read-only' and...
No activity results to display
Leave a comment: