chefdiddy
08-25-2004, 06:53 AM
I want to do something very simple just don't have enough common sense to figure it out myself.
I have a very basic data entry form used to enter new products and size statistics. Many products have the same size statistics so to cut down on the amount of data entry I want them to be able to select a product that was already entered from a list box and then populate the fields on the form with the stats from the selected product.
I have been trying to use the "SetValue" command to populate each individual field based on a DLookUp Function once they select the product form the list. I keep getting an "Action Failed" error when I try this.
Usually I can fumble around long enough and figure stuff out but this has me stumped. Am I going about this the wrong way or am I close and just missing something simple? Thanks!
I have a very basic data entry form used to enter new products and size statistics. Many products have the same size statistics so to cut down on the amount of data entry I want them to be able to select a product that was already entered from a list box and then populate the fields on the form with the stats from the selected product.
I have been trying to use the "SetValue" command to populate each individual field based on a DLookUp Function once they select the product form the list. I keep getting an "Action Failed" error when I try this.
Usually I can fumble around long enough and figure stuff out but this has me stumped. Am I going about this the wrong way or am I close and just missing something simple? Thanks!