Unbound fields

[neilmcmor]

I have a form bound to a table that passes several parameters to a query. However there is one field within the form that is unbound that I would also like to pass to the query. I have been unsuccessful in doing it. I have tried to pass it the same way as the others i.e:-
[Forms]![Form name]![Unbound date field]. Has anyone got any idea where I am going wrong.

 

[KenHigg]

Looks like you have it correct however I notice you are trying to pass a date field so you may need something like the following in the query:

#[Forms]![Form name]![Unbound date field]#

 

[neilmcmor]

Tried that Ken but still not working. Now saying it is an invalid date

 

[KenHigg]

Hum...

Like #[Forms]![Form name]![Unbound date field]#

And are all of your field values dates? or does some have nulls and/or other data? (like and errantly entered date like 121/07 instead of 1/21/2007?)

 

[neilmcmor]

Thanks Ken. Sorted

 

[KenHigg]

Did the like fix it? I was going to say you may need to run it through an IsDate() before attempting to use it...


ken

 

[neilmcmor]

No the problem was where I was placing the [Forms]![Form name]![Unbound date field]. I had it in the criteria row as opposed to the field row. Is it possible to have a form button disabled until a condition is true with other field values. I have a button, (appendbtn), that I want disabled until 2 fields, (Day) and (DayCheck) are equal.

 

[KenHigg]

Been there done that -

 

[missinglinq]

In the properties box for appendbtn set Enabled to No. Then

Private Sub Day_AfterUpdate()
 If Me.Day = Me.DayCheck Then
  appendbtn.Enabled = True
 Else
  appendbtn.Enabled = False
 End If
End Sub

Private Sub DayCheck_AfterUpdate()
If Me.Day = Me.DayCheck Then
  appendbtn.Enabled = True
 Else
  appendbtn.Enabled = False
 End If
End Sub

Private Sub Form_Current()
If Me.Day = Me.DayCheck Then
  appendbtn.Enabled = True
 Else
  appendbtn.Enabled = False
 End If
End Sub

 

[neilmcmor]

Its not working unles I switch it to design view and back. Could it be because the DayCheck field is unbound?

 

[neilmcmor]

Fixed

Thanks I got it sorted now. Thanks for your help, very much appreciated

 

[missinglinq]

Glad you got it working!