jacksonwearn
New member
- Local time
- Today, 15:45
- Joined
- Jun 14, 2013
- Messages
- 9
I've been attempting to write some vba code to generate a form based on the record on a table. I'm not sure how to approach, as I'm fairly new to access. I tried using DoCmd.RunCommand acCmdNewObjectAutoForm. This seems like a good start, but I'm trying to make a tool that will generate a form for every row in a table.
I also thought about having a blank form, using vba to fill out the fields from the table and then somehow saving it as a new form. I'm not sure if this is possible. If anyone could give me some advice, or point me in the right direction it would be much appreciated.
EDIT: If the second approach is possible, it would suit my needs better. I'd like to have some command buttons on each of the forms to move back to an index form. If the forms were all generated automatically I'd have to add these buttons myself.
Another potential solution would be to create a temporary form. Again, I'm unsure if this is even possible.
Thanks
I also thought about having a blank form, using vba to fill out the fields from the table and then somehow saving it as a new form. I'm not sure if this is possible. If anyone could give me some advice, or point me in the right direction it would be much appreciated.
EDIT: If the second approach is possible, it would suit my needs better. I'd like to have some command buttons on each of the forms to move back to an index form. If the forms were all generated automatically I'd have to add these buttons myself.
Another potential solution would be to create a temporary form. Again, I'm unsure if this is even possible.
Thanks
Last edited: