Replies

Hmmmmmmm

Well I really didn’t want to have the form open, I wanted the Summary form as a stand alone.

Perhaps I need to look along other ways to do this, SQL maybe.

Thanks any-way.

Dave

Perfect Hans
Thanks.
p.s Send my warmest regards to Mrs Hans

Dave

Cheers Hans.
I’ll mess about with it a bit

Dave

Hans
Managed to sort it with the following:
Just a small prob with the setfocus and dropdown.
After update, the report prints and sets the focus back to the combo but doesn’t dropdown.
Any Idea’s
Dave

Private Sub cmbPrinting_AfterUpdate()
Dim stDocName As String
stDocName = Me.cmbPrinting.Value
DoCmd.OpenReport stDocName, acNormal
Forms!mnuworkshopmanager.SetFocus
Forms!mnuworkshopmanager!cmbPrinting.SetFocus
Forms!mnuworkshopmanager!cmbPrinting.Dropdown
End Sub

Thanks Hans
I’ll study it in more details.

Dave

Hans

Just got round to mess about with this.
I’ve tried to re-produce what you have done with your example.

I’m a little stuck on a couple of things.

You have several tables and one query, I have set the primary keys in my tables.
I’ve used the MStreeview 5.0 wizard but am now unable to have duplicate values, (understandable)

I’m making mine as follows.
FORD
ESCORT
MONDEO
GALAXY etc

Can you provide a simple overview on the way you set yours up.

Dave

Thanks for the input.

I know where to start looking now.

Dave