why aren't my forms bound?

[merlin777]

I am creating a form for data entry into my main table. It shows all the fields including a name, date, id number etc.

I am trying to put a subform on the form containing a query. The query has two filter parameters fed from two unbound boxes on the main form (date and name). Their purpose is to filter records on the query to just show those for one person on one day. It also calculates a duration based on a start and end time. The query results are ok.

I can't get the query to display properly in the subform.

Subform Properties/data/source object is set to the query name. I'm told i have to link the master fields and child fields but when I try I get the error 'can't build a link between unbound forms'. I thought all that was necessary to bind forms was for there to be a common field between the form and query? Both contain fields from the main table including date, name, start time and end time etc.

I think i may have misunderstood the concept of binding forms?

 

[jdraw]

Can you post a copy of your database (remove anything private/confidential) as a zip?
How are the main form and subform related?

 

[merlin777]

here you go. Forgive the untidiness, I'm using it to learn access and i'm leaving a bit of a trail...

 

[jdraw]

Here is a tutorial you should work through. You will learn about normalization, entities and relationships.
I recommend you start with a clear statement of WHAT you are trying to do. Then identify the things involved. The tutorial will help you.

Your tables don't have any relationships. What does the database represent?

 

[merlin777]

I did have some but I had to keep taking them off to make changes and that's how it is at the moment. There should be relationships between the tblappointment table and tblpatient, tbltherapist and tbltimes.

The database records therapist's appointments, allowing them to see existing appointments when they make their bookings. It will then report weekly timetables for each of 20 patients.

Thanks for the link. I'll work my way through it.