Ask Your Question

Revision history [back]

Base Attempting to select from list box sub-form to populate main form field - how to make this work?

File uploaded: (/upfiles/15475226692499027.odb)

I've created a "Sales Entry-Maintenance" form (created with Wizard) with a sub-form of the ItemMaster table in a list box. No queries, no macros are used. The "Sales Entry-Maintenance" form is where I intend to be entering sales. When it is time to enter a value in the main form Sold_Item field, I need to select a record from the sub-form representing the item sold. I will need to scroll up or down to find (or search for) the correct ItemMaster record) in the list box. Once selected, the ID (key) of the Item record would populate the Sold_Item field in the main form.

At least I think that's how it should work - how I want it to work...

I'm new to Base, please be kind as I struggle to explain what help I need. I'm afraid I'm lost this time...

Thank you so very much, in advance!

Base Attempting to select from list box sub-form to populate main form field - how to make this work?

File uploaded: (/upfiles/15475226692499027.odb)C:\fakepath\dbk-production.odb

I've created a "Sales Entry-Maintenance" form (created with Wizard) with a sub-form of the ItemMaster table in a list box. No queries, no macros are used. The "Sales Entry-Maintenance" form is where I intend to be entering sales. When it is time to enter a value in the main form Sold_Item field, I need to select a record from the sub-form representing the item sold. I will need to scroll up or down to find (or search for) the correct ItemMaster record) in the list box. Once selected, the ID (key) of the Item record would populate the Sold_Item field in the main form.

At least I think that's how it should work - how I want it to work...

I'm new to Base, please be kind as I struggle to explain what help I need. I'm afraid I'm lost this time...

Thank you so very much, in advance!

Base Attempting to select from list box sub-form to populate main form field - how to make this work?

File uploaded: C:\fakepath\dbk-production.odb

I've created a "Sales Entry-Maintenance" form (created with Wizard) with a sub-form of the ItemMaster table in a list box. No queries, no macros are used. The "Sales Entry-Maintenance" form is where I intend to be entering sales. When it is time to enter a value in the main form Sold_Item field, I need to select a record from the sub-form representing the item sold. I will need to scroll up or down to find (or search for) the correct ItemMaster record) in the list box. Once selected, the ID (key) of the Item ItemMaster record would populate the Sold_Item field in the main form.

At least I think that's how it should work - how I want it to work...

I'm new to Base, please be kind as I struggle to explain what help I need. I'm afraid I'm lost this time...

Thank you so very much, in advance!

Base Attempting to select from list box sub-form to populate main form field - how to make this work?

File uploaded: C:\fakepath\dbk-production.odb

I've created a "Sales Entry-Maintenance" form (created with Wizard) with a sub-form of the ItemMaster table in a list box. No queries, no macros are used. The "Sales Entry-Maintenance" form is where I intend to be entering sales. When it is time to enter a value in the main form Sold_Item field, I need to select a record from the sub-form representing the item sold. I will need to scroll up or down to find (or search for) the correct ItemMaster record) record in the list box. Once selected, the ID (key) of the ItemMaster record would populate the Sold_Item field in the main form.

At least I think that's how it should work - how I want it to work...

I'm new to Base, please be kind as I struggle to explain what help I need. I'm afraid I'm lost this time...

Thank you so very much, in advance!