Theodore- If you can put a function call in the Record Source query that includes in the parameters at least one field in the recordset, you should be able to fix the problem. What is the Control Source? What is the code that calculates the value? Are you requerying or refreshing from any event in the form?
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of tyki9799 Sent: Wednesday, January 18, 2006 5:47 AM To: [email protected] Subject: [ms_access] Continuous form problem Hi to all! I have a continuous form with a calculated textbox. The calculation comes by some code in the form’s module. The trouble is that this textbox shows the same result for all form’s records. The correct one is the one in the current record. I know this is common problem with continuous forms. What should I do so that the correct calculation shows for every record? Thanks in advance Theodore Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
