Search form

[gerdagan]

Hi all,

I'm sure this is a simple fix, but I am going out of my mind trying to figure this out.



What I am trying to do is open the Form 'F-Booking' to the matching record as stated in the Form 'F-Date' when the date is selected using the combo boxes.

I hope someone can help, because this simple little thing is just wracking my brains . All of the data for the lookup is in the Table 'T-Dates'.

I've attached the test DB I am working on.

Thanks all,
Ged.

[Robeen]

What happens when you click 'Continue'?
Is clicking Continue what is supposed to open the other form?

[Robeen]

I just looked at your forms & tables.
I can't figure out what you're trying to do.

Can you be a little more explicit?

1. What date do you enter in Form 'F-Date' ?
2. What record do you want to see Form 'F-Booking' opened to?
3. What is the matching field in Form 'F-Booking' that you will use to match to the date you entered in Form 'F-Date'?

[Robeen]

There may be a problem with the fact that the field you're trying to match on F-Booking' is not bound to a single field in your T-Dates table - but rather to a composite of three fields in the table.

Access works really well when you keep it simple.
If you get tircksy like that . . . the coding you have to do to get things to work becomes a little more involved.

Is it possible for you to just have a regular date field on both Forms to match?
If it is, then you can put something like this:
DoCmd.OpenForm "F-Booking", , , "DateFieldOnF-Booking = #" & Me.DateFieldOnF-Date & "#"

Hope this helps.