Coding help!!!!

[deepaksharma]

Your attached file does not have a Dashboard just a single Split Form?

Please look #1

[deepaksharma]

Minty and Micron you are both right.
You both are welcome and thank you both for replying.
Now I wait for June to check the coding. Post #25

[mike60smart]

This version still has a Split Form

[deepaksharma]

This version still has a Split Form

please check now.

[mike60smart]

Check this version.
I don't know how the Parameter Prompts are being generated but the Close Form now Closes Registry and Displays Dashboard.

[June7]

Don't know what else to say. This is the SQL in List132 RowSource:
SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE GREY_SHADE.OfferID=[OfferID];

Explain what "not getting success" means - error message, wrong result, nothing happens?

[deepaksharma]

Check this version.
I don't know how the Parameter Prompts are being generated but the Close Form now Closes Registry and Displays Dashboard.

Welcome Mike, you have suggested a substitute.
This does not close the dashchild form on the dashboard but closes the dashboard itself and opens the dashboard again based on the black row source, making it appear to the user that only the form open on the dash child form has closed.
This does not solve the main problem.
thanks.

[deepaksharma]

Don't know what else to say. This is the SQL in List132 RowSource:
SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE GREY_SHADE.OfferID=[OfferID];

Explain what "not getting success" means - error message, wrong result, nothing happens?

I have put the code mentioned by you in the row source of the list box. After this, me.list132.requery code has also been set in the on current event of formoffer register.
Now when I run the offer register and click on any offer the shade and meter related to the offer are not getting updated in the list box but all the shades and meter in the gray shade table are showing in the list box. This is the main problem coming.
Whenever the user clicks on an offer, its shade and meter should be shown in the list box and not all the shades and meter of the gray shade table.
thank you.

[mike60smart]

The dashchild form is NOT visible as it is unbound so it is not possible to close it

[CarlettoFed]

See if this matches what you would like.
A1send.zip

[deepaksharma]

See if this matches what you would like.
A1send.zip

Yes thanks, it is working perfectly. But I also wanted to understand something from June. He was telling about some problem in SQL. well...

[June7]

As I stated in post 24: "The listbox SQL I suggested does work for me. Would need to Requery the listbox when navigating records. So in Dashboard Current event - Me.List32.Requery".

So there are 2 ways to accomplish a "conditional combobox/listbox". One sets RowSource property via VBA, the other has static SQL in RowSource and code runs Requery.

[deepaksharma]

As I stated in post 24: "The listbox SQL I suggested does work for me. Would need to Requery the listbox when navigating records. So in Dashboard Current event - Me.List32.Requery".

So there are 2 ways to accomplish a "conditional combobox/listbox". One sets RowSource property via VBA, the other has static SQL in RowSource and code runs Requery.

Welcome June, thank you very much for replying.
I have tried to directly open formofferregister many times to directly by writing me.list32.requery code in the current event of formofferregister. Today I tried several times by putting the code in the current event of the dashboard but still don't know why it is not working. Please see my post 25 in which I have also attached the file.
thank you.

[June7]

I looked at db in post 34. Still did not use the SQL statement I suggested. Remove the form prefix.

Also, rename OfferID textbox to tbxOffer and reference textbox name. Apologies, I forgot this part.

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

[deepaksharma]

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

Yes now it is working perfect, at first I was very worried.
thank you so much