Filling in fields in a form from fields in same table.

[rosefield]

I am working on a pedigree form and in the table I have information on sire and dam, which they are also animals in the database. What I am trying to do is when it comes to filling in the fields for the sire or dam that I can look up the animals name and then be able to auto-fill in the sys-id, code, name, reg number fields from what ever animal is selected.

I have seen where this can be done from separate tables but not from the same table.



Thanks,

[ssanfu]

Maybe look here:
http://www.fabalou.com/access/genera...gy_example.asp
http://youngandsavvygenealogists.blo...-2013-for.html
http://www.databaseanswers.org/data_...logy/index.htm



Maybe https://bytes.com/topic/access/answe...ccess-database
download the mdb from http://clienttemplates.content.offic...tp01076524.cab

[rosefield]

After hours of searching and trying I finally found and figured out how to do it.

First, I had to make the field on the form to be a combo box, then I selected to get the value from a table or query. I have 2 queries, one that sorts out the females and one that sorts out the males. I selected the fields that I needed and set my query.

Then on the same field I went to the event tab on the properties sheet and on the "on change", I selected [event procedure] and then set up a procedure to take columns from the query to fill in fields on the form.

[ssanfu]

Glad you figured it out

I would have used the after update event. I don't think the on change event is doing what you think.... but if it works, what do I know???


The change event fires every time you press a key. So if you try typing a "Sire" name, say "Seattle Slew", the change event fires 12 times.
Try this. Ensure the form header is displayed. Enter this line in the change event for the combo box"

Me.FormHeader.BackColor = Not (Me.FormHeader.BackColor)

Then type in a "Sire" or "Dam" name.

If you never use autocomplete and only select names using the list, never mind.
And if I didn't understand, ignore the above.