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
This version still has a Split Form
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Check this version.
I don't know how the Parameter Prompts are being generated but the Close Form now Closes Registry and Displays Dashboard.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
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?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
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.
The dashchild form is NOT visible as it is unbound so it is not possible to close it
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
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...See if this matches what you would like.
A1send.zip
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Welcome June, thank you very much for replying.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.
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.
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];
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.