Highlight "grouped" records on a form

  • Thread starter Thread starter Peter De Tender
  • Start date Start date
P

Peter De Tender

Hi,

I have a list of products using a continuous form like this

group product price
AA 123 1?
AA 456 2?
BB 12 2?

Just like using a report, I was wondering if it is possible to draw a line
or whatever "attention" action (eg. change fonts, colors,...) between the
lines where the group data has changed.

I've been trying with the Dlookup function to read the value in the next
line - this works - but then I'm stuck.

I used the following code where de result from the Dlookup is stored in
field "Dlookdata"

If me.groupnr.value <> me.dlookdata.value then
me.line1.visible = true
else
me.line1.visible = false
end if

but this doesn't work.

I hope someone can help me on this one.

Regards,

Peter
 
Back
Top