ACCESS FEED: Re: [MS_AccessPros] After subform is made visible, it is not displaying records linked to parent

Sabtu, 29 Oktober 2011

Re: [MS_AccessPros] After subform is made visible, it is not displaying records linked to parent

Hi David

Instead of having 3 yes/no fields, you should have a table to define the work types, and a related table with each work type chosen. That way, there is just ONE field to filter and search for. I imagine your subforms are different depending on work type anyway.

to requery a subform:

me.subform_controlname.requery
or, which is technically more correct:
me.subform_controlname.form.requery

Warm Regards,
Crystal

* have an awesome day :)

________________________________
From: djsdaddy531 <drtolson@verizon.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Saturday, October 29, 2011 12:22 PM
Subject: [MS_AccessPros] After subform is made visible, it is not displaying records linked to parent

Great Day, I have a form that permits the user to create a work order for vehicle repair shop. There is a subform that allows the user to enter the types of service needed: Oil Change, replace brake pads, tune up etc. Each field can be associated with 1 or 3 categories:

1. Estimate (Is this service need part of the estimate);
2. Repair Order/Invoice (Is this service need part of the repair order);
3. Recommended (Was this service need something that the technician discovered while (let's say) changing the oil, and makes the recommendation to the owner. In this case, the tech may see that the oil pan gasket needs to be replaced).

Each of these three categories are Yes/No data types. There could an instance when an owner comes in and wants an oil change and a transmission flush, but also hears a squeak and wants the technician to find out what it is. The technician may find that the squeak is a bad wheel barring and the cost may be $350. Although this will be part of the estimate, the owner may decide to get the work performed at a later date, so replacing the wheel barring does not become a part of the Repair Order/Invoice. Consequently, in this case, category 1 and category 2 will be clicked for the Oil change and transmission flush, but the replacement of the wheel barring will only have category one (estimate) clicked.

So the form includes all items - estimates; repair orders, and service needs that are recommended by the technician. What I am trying to do is place 3 command buttons on the main form that will filter the form to only display records for one of the three categories, and a fourth button to show all categories. I have placed three copies of the subform overlaying the first subform (all categories), and here is the copy of the code for one of the buttons (all of them are virtually the same)

Private Sub btnEstimateFilter_Click()
Me.frmScopeOfJobSub1.Visible = True
Me.frmScopeOfJobSub.Visible = False
Me.frmScopeOfJobSub2.Visible = False
Me.frmScopeOfJobSub3.Visible = False
Me.Refresh
Me.Requery
End Sub

All of the subforms are linked to the parent by JobID, but after the buttons are clicked, the proper subform comes up, but I am not getting the records linked to the JobID. It is basically an empty form.

Any suggestions on how I can get all of the subforms to show the records for that particular JobID. Thanks in advance for your assistance.

r/David

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]