problem to populate child form

[eugzl]

Hi All.


I have child form has two cascade combo boxes. The Device cascade combo boxes has 3 levels and the Location cascade 5 levels. Only the last level of both cascade combo boxes is bound control. I need help to display values of a record on all controls of the child fRequest form when I open it by double click record on ListBox of the parent fInventory form. Now when I double click record all controls related to Device and Location keep blank. I will appreciate if someone will show how it to do on a sample.
Thanks

[orange]

You will probably get more focused advice if you
-post a copy of what you have
-provide a plain English description of the "business process(es)" this code is intended to support.

[eugzl]

Hi orange. Thanks for reply.
The attached file is my last version of DB.
Like I mention in first post I would like to pass record from parent form to child form. For that I created double click event in ListBox. But now not all controls in child form are populated when double click executed. I will appreciate if you will show how to fix the problem.
AddNewCascadeCB.zip
Thanks

[orange]

When I open your database and fInventory I get this error message??



Please provide step by step instructions to highlight the issue/problem.

Where is qRequest2?

?lstRequest.rowsource
SELECT [qRequest2].[Request_id], [qRequest2].[Date], [qRequest2].[Device], [qRequest2].[Request], [qRequest2].[Amount], [qRequest2].[Location] FROM qRequest2 ORDER BY [Date];

Are there pieces to this that you haven't told us about?

[eugzl]

Sorry. I forgot to delete this form. Please, delete f_Inventory form or ignore it for less confuse. And use only fInventory form.

[eugzl]

Sorry. I forgot to delete this form. Please, delete f_Inventory form or ignore it for less confuse. And use only fInventory form.

[mike60smart]

I added a new record using fInventory Form and it works just great?

What is your problem with it??

[eugzl]

Hi mike60smart. Thanks for reply.
I don't have problem to add a new record. My problem is to populate fRequest child form when I double click record on ListBox of the fInventory parent form. Now when I performed double click event on ListBox all combo boxes keep blank when fRequest form populated. What need to do to populate all controls in child form?
Thanks

[orange]

Can you provide step by step of how to highlight your issue?

I can double click the listbox, but what am I expecting in fRequest?
If I click other boxes I get errors --- object doesn't exist sort of thing.

Brand is not a selection in the query/rowsource of listbox so it won't populate the control on fRequest.

We need specific info from you
-what do you want to happen when you click on the listbox (please be precise)

[eugzl]

In my second post I attached file. Please, download it and you will see the problem to populate child fRequest form.
Thanks

[orange]

I am working with your database. I have deleted form f_Inventory.

Please respond to my request for detailed instructions to highlight your issue.
Also, please tell us what controls (specifically) you want populated on that DoubleClick event.

[CarlettoFed]

Not having figured out how to use the cascaded "Combo Box" controls yet, in the form fRequest you must enter the following event:

Private Sub Form_Current()
    Me.cboBrand = DLookup("BrandID", "tblDevices", "DeviceID = " & Nz(Me.DeviceID, 0))
    Me.cboDeviceType.Requery
    Me.cboDeviceType = DLookup("DeviceTypeID", "tblDevices", "DeviceID = " & Nz(Me.DeviceID, 0))
    Me.cboDevice.Requery
End Sub

but you keep making mistake about mistakes, see: in the fRequest there are the cboFacility, cboBuilding, cboWing, cboFloor, cboLocation "Combo Box" controls which make no sense as they do nothing. The Required property is hardly ever used correctly by setting it to Yes where the data is needed.

[mike60smart]

Hi
I added a table named "tblCurrentRequests"

Now when you DoubleClick a record from fInventory - fill in the Form for a Request - Save the record it nowgets inserted into tblCurrentRequest.

[eugzl]

In the fInventory form has ListBox. I created double click event in the ListBox to open record in the fRequest child form in case if need to update selected record. Now when I try to populate fRequest form all combo boxes on this form don't display data. I would like to fix this problem. As a final result when double click event executed all controls in the fRequest form should be get data from fInventory form.
Thanks

[eugzl]

Hi mike60smart. Thanks for try to help.
I don't have problem to save a new record. My problem is to populate form fRequest from the fInventory parent form.
Thanks