Dlookup to auto complete in form

[custhasno]

Hi,

I am pretty noob on Acess so even simply pointers to relevant guides or threads would be a great help.

I am creating a database for registering horses and owners, with a serperate table for each (horses have a unique Id as do members, and single members can own multiple horses)

Members will be registered using a members form which captures contact info and assigns the unique ID.



What I wish to do is to create a form for registering horses, within which I want an information box which displays a Members name after I input the member ID on the horse Reg form.

I know the concept is likely dlookup, but im a bit lost as to how i add this to the form, as the memebr Name is not in the Horse reg table, so I dont know how to add it to the form.

I have attached the DB, its basic but i dont want to build it any further until i know what to do incase i need to go back to drawng board.

Any help would be greatly appreciated.

[Robeen]

One possible way to do this is to use a SubForm.

Your two tables already have an implied relationship in the MemberID fields. You will need to create a relationship/link between the two tables.

Create a [sub]Form that shows all the data you want to display in your 'Information Box'.

Then attach the SubForm to your HorseRegistration Form.

When you enter a new MemberID in your HorseRegistration Form, the Member information will show up on the sub form.

There is a good explanation here:
http://office.microsoft.com/en-us/ac...005187803.aspx

Let me know if this helps.

[custhasno]

Hi Thanks for the info, I just gave it a go, read a little form the link too
I get an error saying expected list seperator or)'

ive reattached the DB with the change ive made, its likely an error on my part but not sure what.