Access 2003 - Creating Buttons from a Table

[Speedy]

Is there a way to create command buttons or create an image(s) from the contents of a table?
For example. I have a table called tdlAreas and when the form opens I want it to create a command button for each record in tblAreas using record data to locate it in the correct position on the screen (X-Y coords that are stored in table)



Table fields are id,name,x_coord,y_coord
The name will contain the button caption, the coords are the location on the screen of the button. I will also have to add an onClick that will make all the buttons run the same function only with different parameter (name) being sent to the function.

Thanks

[Jas_The_Ace]

It's pretty complicated. It takes about 100 lines of code.
You have to be able to understand recordsets, CreateControl, Module.CreateEventProc, Module.InsertLines

A much simpler way would be to create a continuous form from tblArea then you can have all your buttons in a column

[Speedy]

I did some research on the CreateControl from your post and I think that might help me out some. I thought about the continuous form but I want everything in one view. tblArea should have very few records and the only reason I'm wanting to code it this way is increase the versatility of the final program, by just having to enter a table record instead of having to program in a new button. I'm new to access and would rather program this in php/mysql but the forces that be really like access so I guess its time to learn. It's a hard convertion going from php/mysql to Access thankfully I have programmed some in visual basic.

Thanks for the advice and any other code snippets on doing this would be greatly appreciated.