Datasheet selection to specific tab page

[RuralGuy]

I used the query to eliminate the OrderBy property setting on the form. The OrderBy Clause is included in the query. Are you saying that when you DoubleClick on the 000030 WorkOrder after the form first loads that the 2nd tab is not on the same record?

 

[JIMR]

I understand the qry after your explaination, thanks. I got the problem corrected between tabs for the 1st record. It had to do with the enter data property, I changed it prior to your assistance.

It is all working great thanks to you, I would not have been able to accomplish this without your help.

I will likely be on here in a few weeks for more help that you may be interested in, once i reach that point in my database. I will be attempting to have access gerenate preventive maintenance work orders.... I am sure it will be very interesting.

Thanks again for your help on this! I see your from Colorado... I wish I lived in colorado.

 

[RuralGuy]

Glad I could help and have fun with the project.

 

[JIMR]

RuralGuy,

I have made some changes to my forms and have ran into a couple of problems with my text link and record souce. Problems started when I changed a form to a form and subform. I have gotten most of the items to work that I need but with some exceptions. I am sure items 1 & 2 listed below are related to the txtlink and likely due to the form/subform but I am lost as to how to get the path correct.

1) txtlink is carring to the WorkOrderID next tab but only for the 1st record in the form that information is being pulled from.
2) the dblClick works and goes to the next tab but also only shows the 1st record in the form that information is being pulled from.
3) In order to get the WorkOrderID from 1 form on the other the record source of the 1st form must be used and it of course carries the WorkOrderID to the next form as expected but with the problem listed in 1 & 2.

However, when using the record source the 1st form continuously requeries. I say this becuase the number of records at the bottom of the form never populates. If I remove it, it stops requering but it also does not carry the data to the next tabbed form.

I can't zip this DB within the attachment limits.

Any suggestions?

 

[RuralGuy]

I can't zip this DB within the attachment limits.

Not even after a Compact and Repair and then zipping it? How about one of the free file hosting sites?

 

[JIMR]

RG,

Here is a file share link if there is a problem with the .zip file.

http://www.4shared.com/file/101466775/6e372340/SAMS.html

You can get to the file by clicking Work Orders on the switchboard. The 2 tabs in question are tab:"Work Orders" and tab: "Work Order Details"

Thanks

 

[RuralGuy]

However, when using the record source the 1st form continuously requeries. I say this becuase the number of records at the bottom of the form never populates. If I remove it, it stops requering but it also does not carry the data to the next tabbed form.

Where are you doing this? Where do you remove it?

 

[JIMR]

Sorry, I left that out.

It is the record source for "sfrmWorkOrders" and when I remove "qryWorkOrders" it stops what I think is a loop somewhere with a requery but it also stops the transfer of the selected WorkOrderID to the Work Order Details Tab.

 

[RuralGuy]

I'm not sure I caught everything but see if this is a little closer to what you had in mind.

 

[JIMR]

RG, you did get all of it thanks.

You created a second qry "qryRawWorkOrders" is this what it took to stop the requery loop or was it necessary to get the txtlink to work. Could it have been to solve both issues.

I also see the name of 2 forms were changed, I suspect this was done to simplify the form name as my focus to make clean standardized names for anything at this point leaves a little to be desired.

 

[RuralGuy]

You created a second qry "qryRawWorkOrders" is this what it took to stop the requery loop or was it necessary to get the txtlink to work. Could it have been to solve both issues.

The answer to this is pretty much YES.

I also see the name of 2 forms were changed, I suspect this was done to simplify the form name as my focus to make clean standardized names for anything at this point leaves a little to be desired.

I'm a real lousy typist so I shortened up those SubFormControl names so it was easier to type. I'm also a fan of not having the SubForm and the SubFormControl with the same name.

Glad it worked for you. Have fun with the rest of the project.