how do i keep my report from loseing its columns when i run it with "DoCmd.OpenReport reportname, acPreview" this is in a2k i work mostly in a97 never had this before i dont know if this always happens
HI Darrylle
I have a report that I created with the label wizard I selected a three column label. The record source is a query when I open the report from the database window it has its columns as many times as I open it. The way my client should open it is from a form that has a 2 column combo box and a command button it the on click event I can change the sql of the query with
Dim mydb As Database
mydb.QueryDefs("queryname".SQL = sqlstring
DoCmd.OpenReport "reportname", acPreview
The first time I open it works fine (3 columns and the margins the way I set then) the next time it only has one column and the margins are 1". When I reset the margins and the columns and open it thru the form the first time it work fine and next time the margins and columns are reset
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.