Recent content by SuzieGirl

Create an unbound subreport, then at runtime set the 'sourceobject' property to whichever report you want to show. Think you need to assign design permissions to the users for the main form though.

I think that the 'Int' should be around the recordset field, rather than the whole bit, and also use 'CInt' instead of 'Int' i.e., RndRecord = (Cint(rst.RecordCount) * Rnd) + 1 Cint converts the expression to an integer type.

I think that the 'Int' should be around the recordset field, rather than the whole bit, and also use 'CInt' instead of 'Int' i.e., RndRecord = (Cint(rst.RecordCount) * Rnd) + 1 Cint converts the expression to an integer type.

Is the subform recordsource based on a query, which takes as a parameter the work order number from the main form, or are you using a filter to say what record you want to display on the subform?

I'm trying to use the shell function to open files, which works fine, as long as there aren't any spaces in the directory path or filename, in which case, it seems to be trying to open each section as separate files, i.e., "C:\my" then "documents\images\a" then "file" then "name.txt", for...