Open form button problems

[grogmi1]

Hello,
I have a main form which in turn has a subform showing the brief details of vehicle checks that we carry out. The subform has a field next to each check 'Date checked' and also a command button which when clicked opens up a another form which shows all of the checks carried out on a particular vehicle on that specific date. The problem I have is that the command button will work on some records but no on all, there isn't even a pattern to the problem !! If a vehicle has 5 checks against it you can click on check 1 and a form will open up showing all of the checks for that date for that car but if you click on say check 3 the form opens up blank yet click on check 4 and it displays the full checks again ......bizarre !! Any help would be much appreciated :banghead:

 

[jdraw]

I suggest you make a copy of the database, zip it and post.
Probably better to see/experience the issue than try to describe it with no code reference.
Also, what are your tables and relationships/ structure?

 

[grogmi1]

Hi Jdraw thanks for getting back to me, I've added the database to a zip file and posted it. It's in its infancy but if you open up form 'Carnumbers' and select vehicle number 3 you will see the dummy check history drop and the problem i'm having with the 'open form' button

 

[grogmi1]

the open form button opens up the 'view vehicle checks' form and the dates on the sub form 'Vehiclechks_TBL-Query' should match the date on the 'view vehicle checks' form

 

[jdraw]

My first impression is that you have a data structure issue.
I do not understand your tables.
Can you tell us in 5-6 lines of plain English and simple terms WHAT exactly is the business you are dealing with? And what are the processes involved?

Also you should avoid naming fields and objects with names having embedded spaces and special characters eg: "\" "/" etc.

 

[grogmi1]

We are a Taxi business and we check our vehicles every 2 weeks. when the vehicles are checked we need to record the details of the checks. The sub form shows a summary of the historical checks I want the open form to show all of the checks for the vehicle on that date. I am still getting to grips with Access so I will take your comments on board thanks and as this database is still in the design stage I can either make the changes you have suggested or just scrap it and start again

 

[jdraw]

grogmi1,

I am attaching a draft data model based on your latest post.

You have Vehicles. You have a series of Checks that you perform on each Vehicle.
Vehicles undergo a number of Checks every 2 weeks. Someone (Inspector) inspects Vehicles.
Each VehicleCheck either Passes or Fails. Results are recorded for historical review.

There was a "similar" request on a different forum that may give you some ideas.

 

[grogmi1]

Looks good, thankyou. Now to put it into practice

 

[jdraw]

Before you put it into practice -test it with test data. If you have any issues, determine if it is the model or the data and change/adjust until it works the way you want. THEN build the actual database.

You can test the model using pencil and paper.

Good luck.