Form not updateable

[DKM]

Hi

Having a few problems with this one. I have form (in datasheet view) driven by a query QryCombPoint (the query combines data from 2 other queries QryMain, QryAVGPoint).

QryCombPoint contains the fields

Ref
Name
Course
Points
AvgofCurrentPoint
MinofMinpoint
MaxofMaxPoint

The CurrentPoint, Min and Max Point fields are all set via QryAVGPoint. I understand that the problem is where a query aggregates records it makes them read only. I am trying to figure a workaround that will allow me to display these fields on my form while keeping the other fields updateable. I have tried using a DLookup but only get an error message back.

Can anyone recomend a way i can set this up.

 

[stopher]

I doubt that you will be able to do this by joining queries.

Dlookup is the way to go I think. What expression are you using for your Dlookup?

Chris

 

[RuralGuy]

This link may help with the DLookup() syntax.

 

[DKM]

This link may help with the DLookup() syntax.

Many thanks for the help

Looking through it i can see where i was going wrong. it is the differnece in the syntax between numeric and text strings that i had wrong. i was trying to work on the numeric data i was returning rather than basing it on the text i was comparing.

 

[RuralGuy]

Excellent! Thanks for posting back with your success.