Forum Discussion
Use Macro to switch Forms and Choose the Same Record
Hi, I have a simple, 1-table database. I want to have two forms, one in tabular/spreadsheet format and the other that shows all the fields on one screen. Each form would have a button to bring up...
Which part are you having trouble with, switching back and forth between forms or selecting the proper record in the called form? Or both?
Here's a small demo. I hope it matches your requirements, but if not, let me know and we'll modify it.
Note: the layout of the forms (datasheet vs normal view) is irrelevant to how it works.