Check Box

[PGM2]

Hello,
I have two tables (DeviceHistory{1Table} & Repair History{Manytable}) which are joined by the Serial# field. I have created a form based off a query of these two tables. My user places these devices on repair using a checkbox and runs a report to verify all serial numbers. When my user places a device on repair by clicking the checkbox with in the form and then checks the report it's showing multiple serial numbers. How can I show the last instance of a issued problem for a particular device instead of all instances of previous problems including ones just placed in. Oh the report is based off the same query but with criteria filter of begin and end date. Thanks in adavnce! Hope it wasnt to lengthy .
Phillip

 

[koala15]

Phillip,

(I am assuming that you have bound controls). (Correct?)

I do not like them (viz bound controls) because using unbounded controls gives me (the programmer) much better control over what happens when an event occurs.

So.... my suggestion is to change the logic to unbounded controls and when an event occurs (such as a checkbox change) fire off a prebuilt DB query such as the following

Set qryDBQuery = dbDataBase.QueryDefs(m_strQuery57)
qryDBQuery.Parameters.Refresh
qryDBQuery.Parameters("Param1").Value = txtEnter1
Set recDBRecSet = qryDBQuery.OpenRecordset()

This is DAO code and should be changed as appropriate.

Am I helping ????

"Life is full of learning, and then there is wisdom"

 

[PGM2]

Thanks for the info. It does help but unfortunatly I have yet to get into that area for database design(programming). I have concluded that in order for me to have a lot more control I will need to build a front end. I have decided to use vb .net. Any suggestions? Also to solve my issue, because I dont fully understand what you have suggested, I am able to just place another filter using the rma numbers that the mantaineance vendor provides to narrow the search to the most recent issues for a device. That should give me time to build the front end. Thanks a lot though!

 

[koala15]

Re your comment: "I have concluded that in order for me to have a lot more control I will need to build a front end"

Actually you do not.

It is just a matter of placing the appropriate controls on your form and then in the appropriate event (Form_Load or Form_Activate or .........) executing the ADO or DAO code to retrieve the data and then just populating the controls as you see fit.

(I find it enjoyable to look outside the walls.)

Cheers.

"Life is full of learning, and then there is wisdom"