Microsoft Access 2007 form - Everything visible in design view but invisible in Form view

I am reletivley new to ms access and have a problem with a form.

We exported the form in question from a known working access db and imported to the db in question which has similar properties.

The problem is that no data appears when looking at 'form view' - 'Design view is fine and all the fields/tables exist as expected.

Not sure where we are going wrong but any help much appreciated?

Who is Participating?
peter57rConnect With a Mentor Commented:
Ok - add the event type to this query and also sort on the eventtype.
You should be able to see if there are any eventtype values which are co or sh, which is what the form is looking for.
The form gats its data from a query involving two tables.
Do you have the same tables in your new database? (They are not present in the sample you posted).
Ripla5Author Commented:

The export is from the main (new) database.
I have attached the export from the known working database and cannot see any differences? - Except the results show in this one when opened from within the actual db itself
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

The form is used to display  data from two table, called Events and Rehearsals.
It is configured so that its only function is to display data.  Data cannot be edited, entered or deleted through this form.
If there is no data to display then that's it.

The data to de displayed is for event types CO and SH and the event date cannot be in the past.
Also there has to be matching records in both tables (matched on EventID)  otherwise no data for that event  will be displayed.

Ripla5Author Commented:

So basically the form does not display data as there is no data to display?

I know that the data is in the new database so is it a case of 're-mapping' the form to find the correct data? If so pointers on this would be very welcome!
"is it a case of 're-mapping' "

Well yes, in principle.  But how involved this will be is anyone's guess.

As I've said, the data source for the form is a query based on two tables, Events and Rehearsals.
Do you have two such tables in your database?
If so then you should open the form in design view and display its properties.
In the recordsource property is the sql code of the query.  Click into this cell and then click the Build button (...) to the right.
Access will try to display the query in the query grid.  Where it finds matching fields it will show the field name and the table name in the column.
Where it can't find a match it will show the field name with prefix like..'Expr1'  and no table name.
You need to find the correct field for each of these. You might also get an error message saying that relationship cannot be created - this will be due to the field names used to link the tables not being present in the new tables
Ripla5Author Commented:
I think the events and rehearsals are in the database yes.

I opened the forms in design view, managed to fit them side by side and take a screen dump, the working db is to the right of the image while the 'non-working' is to the left. After clicking the (...) I get the attached.

I can't see any prefixes like you mention - Am I looking in the right place
Ripla5Author Commented:
Also a screen dump of before clicking the (...) if thats any use?...

The values you show relate to the highlighted textbox, not to the form.
To show the form properties, double click the box to the left of the horizontal ruler.
Ripla5Author Commented:
I think I got it, working and non working attached.....

There are some obvious differences in the non working which are highlighted in red but I still can't see anything which stands out as the casue of the problem.....

I suggest that you do this..
In the 'non-working' version find the query view again, and this time double click the 3 missing fields to add them in to the grid.

Then click the SAVE button and save the query with a name of say qryEventData.

close the query- say Yes when asked if you want to update the property.

Close the form.
Now open the saved query and see if you get any records in the results.

If you don't -i supect you won't - then that means there is no data which satisfies the criteria and you will have to start looking at that.
Ripla5Author Commented:
No joy I'm afraid and I'm probably already well out of my depth here so looking at data which essentially doesn't exist makes me even more nervous - Is this something which is relatively straight forward?

Sad thing is I'm ok with SQL in relation to MYSQL and PHP, I'm assuming access works on a similar format its just understanding where everything is and how to piece it together!
I suggest you create a simple query to see what is going on.
Start a new query in design view and select the two tables.  The join should happen automatically.  Then add the eventid , event name, eventdate and eventexpdate from the event table and the rehearsalid and rehearsal night from the rehearsal table just by doubleclicking in the field lists.
See what you get.  

If there is still nothing in the results then you have some data issues;  it would mean that there are no records with matching eventid values.
Ripla5Author Commented:
Hi Peter, your patience is inspiring!

Ok, I managed to do everything as you suggested - hey presto we have data results after clicking 'run'.

Still not clear what this means but by the sounds of it we have a starting point!
Ripla5Author Commented:
Looks like we are getting somewhere now.

Understood where you are coming from and one-by-one I have run the query each time, I found that the datafailure occured when I added the filter '>Date()' to the 'EventExpDate' query.
I don't actually need this as I can sort by ascending, but for now it looks like the penny has well and trully dropped - I now understand that I need to understand each and every data field > what it relates to, and that a query has to be created before a form can be viewed - I've learned more about access in one day simply with your help and a bit of luck!

Thank you for your help!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.