Recent content by Killdozer

I have 8 different crosstab queries showing the sum of the "total" from the quert from which they were made. I then made one Query combining the 8 crosstabs into one query. I made a report of the Combined query. With a text box in the report footer showing the sum. All the calcs work fine unless...

Thanks, finally got it to work, I tried a 1 as well earlier, but no luck. I got rid of the combo box from the form, and used the lookup in the table properties for the drop-down list. And I based my form directly on the table, not a query of the table as I tried previously Thank-You very much...

Thanks Paul, you were right. So I created a new test table, and form with combo box, I no longer get errors, but the price is not showing in the Price field. The Combo box is called Combo6, having two columns: Item,Price. The Table has three field: ID, Item, Price. The form has the same as the...

Hi, I tried what you suggested. My combo box is named: Combo23, My Cost field is called: RentalFees, So in the afterupdate of the event section of the combo23 properties, I typed: Me.RentalFees = Me.Combo23.Column(1) I get an error as it cannot find the object Me. I attached an image of the...

In my table, which is used to produce cost estimates. The two fields that I'm concerned with are: [Item], [Cost]. I have a combo box for [Item] which get the data from another table called "inventory" having two columns, Item, Cost. Using a form based on the table, When making a selection from...

Your a Genius. I just changed it so it would preview the report. Works great. This sure saved me a lot of time from having to build a report from scratch off a new query, then try to figure out the calculations I need. Thanks ever so much! Can I add you to my friends list? Phil Killdozer

Hi again, I was able to get my report to reopen from my form, the one part of the script that I;m not sure about is: strCriteria = "[FieldInYourReportThatYouWantToFilterBy]= " & Me!controlWithSelectedItemToFilter I changed it to: strCriteria = "[TrialNO]= " & Me!TrialNO I renamed the field...

Re: Print Report Showing Current form info Ok, I will make a query wilth the calculations I can, and do a report from that. The db I messed up was my backup copy on my mem stick. My good copy is on my work computer. I will try to shrink my db down enought to attach to the forum. I will be...

What I have is a main form with just a few fields, like the [trial No], [Trial name], ect. This is shown in the Form view. Then I have four other forms inserted into the main form as subforms, these subforms show their data in the data sheet view, all are linked by the [Trial No] which is the...

My report is based on my form, basically I justed saved my form as a report. My form is based on 4 seperate queries. I did try placing the info in the criteria of the querry which makes up the main form in the [trial file no] field. The rest are sub forms, I then opened the form then the report...

Thanks Wiklendt I tried to get it to work today, using various ways and locations for the script. So for the button, are you referring to a command button on my form to open the report in print preview? I tried putting the command in the prosperities of the report so when it opens it would...

OK thanks, sounds complicated though, as I don't have any visual basic skils. Not sure how to bring up the "DoCMD". Is there a way under properities of the report under data source or someething like that to link my primary key from form to my report. or can I write a macro that would do the...

Hi, I created a report from a form with 3 subforms. The report works fine, but how to I get it print with the current infomation or current record that is showing on the form, beside forwarding to the next record once in the report. Not sure I explain this correctly, basically when I open the...

Thanks alot Paul, I think I got it, I will continue tomorrow Phil

That was it, it now works. So my next questions is, this form will be one of 3 subforms on the main Form. So on the main form, can I put in a calculation to total all the subforms totals.