Coding help!!!!

[deepaksharma]

I have created a dashboard on which there is a child form named dashchild.
When the New Offer button on the dashboard is clicked, the offer_entry form opens on the dashchild form due to the code written in it.
Similarly, by clicking on the Register button, the form created in the navigation bar should open in the offerregister dashchild form.

But there is a list box in the formofferregister in which I have written a criteria in the offer ID field in the record source which is generating a popup error.
Please help me. Just like the form offerregister is opening in split view in independent form, similarly I want to open it in split view on dashchild form created on dashboard.
Thank you.

[Bob Fitz]

Try this:
Remove the RowSource property of List132.
Use the following code in the OnCurrent event of formOfferRegister:

Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)= " & Me.[offerid] & "))"

EDIT

Alternatively, you could just change the RowSource property of List132 to:
SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)=[OfferID]));

[deepaksharma]

Try this:
Remove the RowSource property of List132.
Use the following code in the OnCurrent event of formOfferRegister:

Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)= " & Me.[offerid] & "))"

EDIT

Alternatively, you could just change the RowSource property of List132 to:
SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)=[OfferID]));

Thanks bob Out of the two codes you suggested, the first one is doing perfect.
Should I keep or remove the me.list132.requery code in the on current event of the form offer register?
As I had asked earlier, how can I see the form offer register in split view on the dashchild form created on the dashboard.
Thank you for help.

[Bob Fitz]

You won't need the requery with the first option but You would with the second option.

[deepaksharma]

You won't need the requery with the first option but You would with the second option.

Thanks please also tell how can I open it in "split form view" on dashchild form.

Form Offer Register Close button is also not working properly when it is clicked the entire dashboard gets closed. Please suggest any proper coding for this also.
Thank you.

[Bob Fitz]

Thanks please also tell how can I open it in "split form view" on dashchild form.

Form Offer Register Close button is also not working properly when it is clicked the entire dashboard gets closed.

Sorry, but I don't use dashboards.
If I were developing the db I would have whatever subforms I needed on the main form and change their Visible property with buttons on the main form.

[deepaksharma]

Thanks I will wait for other experts like you here

[Bob Fitz]

Thanks I will wait for other experts like you here

Thank you for your kind words but I'm not an expert.

On reflection, I think I might use a Main Menu form for the buttons to do everything else.

Perhaps something like the file attached.

[June7]

Did you simply set SourceObject property?

Parameter in List32 SQL will not work. So it will work when form is standalone or subform, modify to:
SELECT OfferID, Shade, Meter FROM GREY_SHADE WHERE OfferID=[OfferID];

[deepaksharma]

Did you simply set SELECT OfferID, Shade, Meter FROM GREY_SHADE WHERE OfferID=[OfferID];

Don't know why but this method is not working.
Would you also please suggest any solution to the two problems I have mentioned above.
Thanks in advance.

Thanks please also tell how can I open it in "split form view" on dashchild form.

Form Offer Register Close button is also not working properly when it is clicked the entire dashboard gets closed. Please suggest any proper coding for this also.

[Bob Fitz]

Use:

Private Sub Form_Current()    'Me.List132.Requery
    Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)=" & [offerid] & ")); "
End Sub

I don't think split forms work on a subform. You may have to use stand alone forms like the forms in the db that I attached in post #8

[deepaksharma]

Thank you for your kind words but I'm not an expert.

On reflection, I think I might use a Main Menu form for the buttons to do everything else.

Perhaps something like the file attached.

Your suggestion is good but I want to proceed as is.

[Bob Fitz]

Your suggestion is good but I want to proceed as is.

Perhaps I can persuade you not to use Access Split Forms with the following YouTube link: https://www.youtube.com/watch?v=UloLIMhatSs
Watch it all. In the second half he shows how to create an alternative.

[deepaksharma]

[QUOTE=Bob Fitz;519112]Use:

Private Sub Form_Current()    'Me.List132.Requery
    Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)=" & [offerid] & ")); "
End Sub

Now this code is working well please tell which one will be the best among these three.

 Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)= " & Me.[offerid] & "))"

 SELECT OfferID, Shade, Meter FROM GREY_SHADE WHERE OfferID=[OfferID];

June's code not working right now.

Private Sub Form_Current()    'Me.List132.Requery
    Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade,  GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)=" &  [offerid] & ")); "
End Sub

[Bob Fitz]

[QUOTE=deepaksharma;519115]

Use:

Private Sub Form_Current()    'Me.List132.Requery
    Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)=" & [offerid] & ")); "
End Sub

Now this code is working well please tell which one will be the best among these three.

 Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)= " & Me.[offerid] & "))"

 SELECT OfferID, Shade, Meter FROM GREY_SHADE WHERE OfferID=[OfferID];

June's code not working right now.

Private Sub Form_Current()    'Me.List132.Requery
    Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade,  GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)=" &  [offerid] & ")); "
End Sub

I believe that I've answered this in post #11.
I do not use split forms. If you are adamant about using them, then I am unable to offer any more help. Good luck with your endeavours.