Search results

Progress: I've created a reference to open a form (called TableChooser) in my report: Private Sub Report_Open(Cancel As Integer) DoCmd.OpenForm "TableChooser", acNormal, , , acFormPropertySettings, acDialog, "" The report is modal and has a drop-down combo box (called ComboChooser) and an OK...

Right, I understand that using a modal form with a single combo-box control will give the illusion of a simple pop-up box. I also understand that a global variable might have to be used so that the selection could be used in both the form and the report. Could you please explain how I would...

Is there a way for a user to select a report's record source when the report is opened? A drop-down list of the database's available tables and/or queries would be optimal, but typing in a table name would suffice (as is done with an "enter parameter value" query for named unbound controls).

It seems that the code works in either the Print or the Format sub procedures. I've pretty much given up on doing it in forms. It works in reports, so. There.

Again, thanks Pat (conditional formatting does work in the Format event, BTW)... Only thing is that I need to use a form, not a report. Any ideas?

Right, thanks. In the mean time, I realized that I really need to do this in a form, not a report, due to the fact that there need to be some modifyable fields for the users. So... Is there any way I can have a printed form pay attention to its visual basic code?

Is there any way I can have each record's controls refresh their conditional VB code for each record printed? Specifically: I have some simple VB code that conditionally hides a control in the form (depending what's in another control). It works fluidly when browsing from record to record...

Is there any way I can have each record's controls refresh their conditional VB code for each record printed? Specifically: I have some simple VB code that conditionally hides a control in the form (depending what's in another control). It works fluidly when browsing from record to record...