Display 'Important Message' On Contiuous Form

[mseeker22]

Yes. . . .

[RuralGuy]

Press the JoinType button and tell me what you have.

[mseeker22]

3. Include ALL records from 'Restaurant Bookings' and only those records from 'Important Dates' where the joined fields are equal.

[RuralGuy]

Great! Can you now create a query with both tables in it that has the extra fields from the [Important Dates] table?

[mseeker22]

Can you just verify for me how I should tell the textbox to display the important date message . . is it simply =[ImportantDates]![ImportantDateName] in the tbo control source . . . I'm thinking not as it's still showing #Name? ha!

[RuralGuy]

You've got to create the query that joijns the two tables first so you can use it as the RecordSource of your form.

[RuralGuy]

I'll check back when I get back from my appointment. I'll be gone for several hours, sorry.

[mseeker22]

When the query has just the 'Important Dates' table in and has =[Forms]![RestaurantBookingsDiary].[DiaryDateEntry] as the criteria, the query works exactly as planned and shows the correct 'Important Dates' . . . but when the query is linked to the tbo it still shows up as name.
When I add the 'Restaurant Bookings' table to the query and include 'Booking Date' into the fields the query no longer returns any records.

I then added the 'Important Dates' table into the 'Restaurant Bookings Query' it still doesn't seem to be working.

Sorry to be a pain!

[mseeker22]

I've just noticed you last message r.e. appointment. I also have to go out and won't be back online until tomorrow morning, GMT.

[RuralGuy]

Are both date fields set to midnight? http://support.microsoft.com/kb/q130514/en-us

[mseeker22]

I'm not sure I fully understand? I realise how access works out date but I don't understand how to set the dates like you suggest?

When the query is run independently of the form it returns the correct date.

[RuralGuy]

When the date is stored, do you use Date() or Now()?

[mseeker22]

Its currently Date()

[RuralGuy]

That will store Midnight which is good. If I understand you correctly, when you look at the Datasheet view of the query with both tables in it you don't get the proper fields from the ImportantDates table, is that correct?

[mseeker22]

I've tried two types of queries. One has just the Important Dates table in and this query works fine on its own. The second had both Important Dates and Restaurant Bookings tables in it and no matter what date is entered into the parameter criteria the result is blank. See both attached.