Programming optional auto-fill

[sergio.tulkas]

Good morning everybody,

I have a problem with access. I am a total beginner and I am working in a company that already uses it.



Doll factory problem.



I have several lists of unique objects (doll parts) identified by their serial number. For instance I have a list of doll heads (SN 1, SN 2 etc..), a list of bodies, right arms etc. Each list is encoded in an access table.



I have also a list of dolls (or standard dolls), defined by a doll serial number and made of a predefined combination of parts, for instance doll SN1 is made of head SN1, body SN2, right arm SN1 etc...



In the factory the dolls are often disassembled and re-assembled and different dolls can use same unique components, for instance


doll SN1 : head SN1, body SN2, right arm SN1

doll SN2 : head SN1, body SN3, right arm SN2



I have a table for each doll part : one for the heads, one for the dobies...and a table for the standard dolls descpription.



We performed many test on the dolls. For each test we used a different doll. We both used standard dolls (defined in the relevant table) and also customised dolls defined ad hoc.





I have a « test » table. In the first column of this table I have the standard doll SN (if applicable), in the second/third/fourth columns I have the doll head/body/right arm SN (always applicable).

If the standard doll SN is empty it means that the doll is a customised one without SN. It has been assembled just for this special test. There is no special table for those custom dolls: they are just described by their part list in the test table.



The question is : how can I make the head/body/right arm SN columns in the test table fill automatically, when the SN of a standard doll is defined? And how can I allow the user to fill those fields manually, if the doll is not a standard one (so there is no doll SN)?

Thanks a lot,

Sergio

[Missinglinq]

Here's a Step-by-step

1. Set up Textboxes on your Form, for all items, each one bound to the appropriate Field in the Form's underlying Table
2. Place a Combobox on your form. When the wizard comes up
3. Select "I want Combobox to look up values in a table/query"
4. Select your Parts Table
5. Click and move each Field to the right hand box
6. Sort by DollName
7. Select "Remember Value for Later Use"
8. Chose a Caption for the Label of the Combobox (if desired)
9. Click on Finish

Assuming that the items were added in the order of DollName, Head, Body, RightArm and LeftArm, in the AfterUpdate event for your Combobox

Private Sub YourComboBox_AfterUpdate()
  Me.DollName= Me.YourComboBox.Column(0)
  Me.Head = Me.YourComboBox.Column(1)
  Me.Body = Me.YourComboBox.Column(2)
  Me.RightArm = Me.YourComboBox.Column(3)
  Me.LeftArm = Me.YourComboBox.Column(4)
End Sub

Notice that the Column Index is Zero-Based.

Linq ;0)>