Command button to open a subform

[nnabbale]

Hi all

I would really appreciate you help.

i created a subform by dragging a form over another, it all works OK as it gives me details about the item Im dealing with in one screen in 2 forms (the main - 'Progress/Status' and subform - 'Saving')

However there is so much detail on the screen and I would like to create a command button on the main form that opens a subform with information only for the current record. I tried to create the command button, but it opens thesubform in form view with all the other records in that form which i dont want to see.

Can you please advice me on how i restrict it give information about the current record and not all records present in the form?

I have attached to db for reference

thanks

 

[pbaldy]

You mean to open as a stand-alone form? If so:

http://www.baldyweb.com/wherecondition.htm

You already have the master/child links set to make sure the subform only displays the records related to the record on the main form.

 

[nnabbale]

Thanks Paul, i have created a control and used the Action Arguments control and entered the following
Form Name: Saving
View: Form
Filter Name: [Forms]![Saving]![ProjectID]
Data Mode: Add
Window Mode: Normal

that macro runs and takes me to the form but opens a new record each time and does show the data that already exits for that record

What AmI missing.

Also i dont know where to enter the DoCmd sql, apologies Im new to this, how do i use that?

thanks a mil

 

[pbaldy]

What I posted was VBA code, which goes here:

http://www.baldyweb.com/FirstVBA.htm

Yours opens to a new record because you told it to:

Data Mode: Add

 

[nnabbale]

Paul

I have followed your instructions and entered the following

Private Sub Command48_Click()
DoCmd.OpenForm "Saving", , , ProjectID = " & Me.ControlName"
End Sub

But it still opens a new record - apologies for being a wooz

 

[pbaldy]

You didn't get the syntax quite right. Try:

DoCmd.OpenForm "Saving", , , "ProjectID = " & Me.ControlName

You also need to replace "ControlName" with the name of the control (textbox, combo, etc) that has the ProjectID value in it.

 

[nnabbale]

Hi Paul

Really appreciate your time but it still hasnt worked, still opens a new record

Really frustrating!!! urrggghhhh

thanks anyway

 

[pbaldy]

What is your code now?

 

[nnabbale]

DoCmd.OpenForm "Saving", , , "ProjectID = " & Me.ProjectID

 

[nnabbale]

I have projectID in the main form (progress/Status) which is linked to the Subform (Saving). If you look at the form on my database called Progress/Status, the savings Subform automatically loads the ProjectID from the main form and keeps the entries for that ID, i would like to open the subform in another window via a command button but have it function the same way as it is in the main form

 

[pbaldy]

Your field name has an inadvisable space in it. This works:

DoCmd.OpenForm "Saving", , , "[Project ID] = " & Me.[Project ID]

 

[nnabbale]

Thank you SOOO Much Paul, that almost brought me to tears, been at it for hours.

I have another question about reports can you help - I hate to impose

MUCH appreciate
N

 

[pbaldy]

Happy to help, and welcome to the site by the way!

A new question should be started in a new thread. It keeps the forum better organized and helps people searching for answers later. I'll keep an eye out for it.

 

[nnabbale]

Cool thanks - will post it now