Search results
-
L
Autofilled data not in table
Probably thanked you too soon... I wish to get more complicated now, by restricting the list that comes up in the third combo, area, based on the productcode. In the criteria section of the productcode field within the productname combo box, I've put [forms]![myform]![combo16] I'm stuck on...- Linda Rossiter
- Post #8
- Forum: Forms
-
L
Autofilled data not in table
Got it. Your help was VERY much appreciated this afternoon... looking through other people's questions, I could see that what I was asking was very basic, and your patience was marvellous. Thank you again!- Linda Rossiter
- Post #7
- Forum: Forms
-
L
Autofilled data not in table
Struggling a bit... In afterupdate, [ProdName]=[ComboName].Column(1) is this an event procedure? I've so far got something like Private Sub Combo53_AfterUpdate() [ProdName] = [Combo53].Column(2) End Sub Second, even more basic question: on the form, where I want the product name to be filled...- Linda Rossiter
- Post #5
- Forum: Forms
-
L
Autofilled data not in table
<<Are you sure that ProductName is bound to a field in the table?>> No, I'm not sure... where do I check? <<How are you adding the product code, via a combo box?>> Yes- Linda Rossiter
- Post #3
- Forum: Forms
-
L
Autofilled data not in table
I can enter the productcode and the productname will automatically fill in, through the relational join, having set the Control Source for the productname to the productcode in the recordset. However, once using the form to enter data, although I see both the productcode and the productname...- Linda Rossiter
- Thread
- Replies: 8
- Forum: Forms