checkup

[canett]

How can i check a field in the table? I have a field called Suborder in the table orders.On the form I have also a checkbox called ChkSuborder. I want to build a code in the OnClick event of the checkbox.This event should check whether there is a field Suborder = true and if so to give out a message " you have some job undone" Obvously this code should open a recordset of the table orders but how exactly is the way to do it ?

 

[JerryKlmns]

You could search on help for Open Recordset method (DAO or ADO).
But I would recommend the DLookup() function as faster.

 

[OhioSteve]

I know how to write the code you describe. However, first I have a question for you.

You say that you want the popup to appear if suborder=true. But suborder is a field in the table orders. That orders table could have 1000 records in it. Do you want to see the popup if ANY of them are true?

I suspect you want to look at a subset of the table orders. And if any record in that subset has subreport=true, THEN you want to see the popup. If my supposition is correct, tell us how that subset is defined.

 

[Zion7]

I'm assuming Steve, it's a single record based on the
current record of the form?
If so, I would include the field on the form,
and invisibilze it (just had to say it, LOL).

If Me.Suborder Then ...

or Like Jerry said,

Dim blnSuborder As Boolean
blnSuborder = DLookUP("Suborder","Orders","pkiD = " & Me.PkID)