I am new to access. Using 2010. Pretty good with excel. I think I understand database basics but I'm having problems with what should be simple.
I'm creating a dabase to track fixtures. Right now I have two forms. One to input / edit fixture data and one to sign out the fixture.
I want to have a button on the fixture input form "Signout fixture" that will open the fixture signout form, create a new record and set the fixture ID to the fixture that is selected in the fixture input form.
I can open the form and select existing records based on the current form. I can open the form and select a new record. I can't open the form, select a new record and set the fixture ID. I've tried macros and code. And I tried to find options when adding a button.
I currently have:
It doesn't work. It says it's misspelled or doesn't exist. I've tried various different syntax and haven't come up with anything that works.
I would think that there must be a very easy solution to this.
Any help will be appreciated.
Thanks,
Ken
EDIT
I also tried using a subform to display the signouts for the selected fixture which was pretty cool but I had the same problem when creating a new record. That was a while back though so I'm not exactly sure. I ended up starting some scratch going with a more simplified approach.
Bookmarks