Search results for query: *

Thank you both for your suggestions, it was the main form I was concerned with, I noticed that it would scroll back with the mouse wheel like you suggested. But the subform acted as it should..All is well thanks again.

I have a form sub form, I have set the properties for both form and sub form to data entry = yes the sub form acts as expected with no records showing to the user but, the main form does not. The main form can scroll back one record, it will eventually not show any records like the sub form if I...

That did it many thanks

I have a form with a print command button. When the button is pushed it prints a report and sets the form with a new record. The focus remains on the print button, Id prefer it to be set to the "drivers" field or the top of the tab order.

Hi Kzutter, I wasn't getting any blank labels..but I decided to add a dymo print button besides the button I use to print the report..I also realized that in my form/subform, I only needed the parent portion of the data for my SQL statement in the reports control source...sheesh Dymo is running...

This might be better if broken down into 2 command buttons instead of a single print button. Maybe a Dymo print button.

Hi, I'm using a form/sub form to print Shipping label(s) and a single report. The user fills in fields on the main/sub form including TotalParcels, the value in the "TotalParcels" is passed through code, and a corresponding number of shipping labels are printed including a single report...

Thanks AceMan, Got it, I put the Me.Parent.Recalc in the "On Change" of the parcels properties...Wow very fast now. This goes in the tool box.

AceMan.. If you mean in my subform, all I have is the "recalc" the form and subform are imported into a switchboard. If you need to see that code I can provide it..

Hi AceMan, The focus remained on the parcels field, wouldn't even tab off there.

Hi forum, I have a form/subform one to many realtionship. On my subform I have a field named parcels. On the main form I have a text box named total parcels using this control source. =DSum("parcels","tblpurchdata","warehouseid=" & nz([warehouseid],0)) I have this in the after update of the...

Yes Duane, I think we can close this thread many thanks!

Thats why it was truncated cause I used the wrong record source for my report...Duh

I think I got it...used the query builder and set the record source from there...right?

my record source for my report is wrong I suspect. SELECT * FROM tblWarehouse, tblPurchData; how do I set it for the sql query?

also I have no "criteria" in the query just raw data but displaying correctly

Yes the query returns the infromation correctly, not truncated. And no there are no subreports.

I created that from the builder in the record source properties

SELECT tblWarehouse.*, tblPurchData.* FROM tblWarehouse INNER JOIN tblPurchData ON tblWarehouse.WarehouseID = tblPurchData.WarehouseID;

Hey guys, I may have spoke to soon on this one, I have been running some search reports and found that I am getting mixed results from the search. While all error messages have gone, I'm getting a kind of truncated report. I get the information the user requests (together on one page) plus a...