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...
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...
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...
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 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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.