Recent content by naygl

Try searching for SendObject in this forum or the Access help.

Nothing wrong there. It may be something to do with the query that ChangeNomexQuote is based on or some programming in the OnOpen action of this form, otherwise I'm stumped. Sorry:(

Not sure I can be much help but maybe you could post the OnDoubleClick Code (that may be where the problem is).

When you say 'full details', does that include the quotenumber and revnumber displayed on the main form? What is your link criteria and is it a primary key/unique value?

You should use the link criteria of the OpenForm command use code like: Dim stDocName As String Dim stLinkCriteria As String 'form to open stDocName = "frmNew" stLinkCriteria = "[Record#]=" & Me![Record#] DoCmd.OpenForm stDocName, , , stLinkCriteria Good Luck.

No apologies necessary.

Is that an Access thing? I was sure that wouldn't work on TOAD.

How's that?

"WHERE Subcons.Pick =""S""" won't work because you don't have Subcons.Pick in your SELECT statement.

I don't know if this helps but I would code it: DoCmd.FindRecord Forms![frmChoose]![subChoose].[Form]![PN]

The tab control and the pages aren't subforms so (I think) you should be able to refer to the label and the checkbox as though they are on the same form where you have the tab control. e.g. me.label1.visible = false instead of Me.tab.page1.label1 etc.

type Null or Is Null into the criteria of the field.

Do you have an ONTimer event going?

Maybe try Forms!frmSelectLocationStartDefault.Form!cmbLocation

Use: If Label1.Visible = True Then Label1.Visible = False Else Label1.Visible = True End If In the on Timer event.