Buttons Dont Work - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Buttons Dont Work

Agatha Miller

5 years ago

I am following the genealogy seminar and I'm on Lesson two at 48 minutes into the lesson. I was able to add the command buttons for mother and father but I can't get the command buttons to work in the child sub-form to add mother or father. I have re-watched the video several times and retraced my steps but the buttons don't work. My buttons don't even open the PersonAddF form the way it does in the video.

	Kevin Robertson @Reply 5 years ago
Saying your command buttons don't work isn't enough. We need more information. Forum Posting Rules Context

	Agatha Miller OP @Reply 5 years ago
I don't know what else to tell you. I copied the button from the Add mother button just like Richard shows in the video, then I enter all the coding Richard shows and after saving my work, I close my PersonF and reopen it and try to add a mother in the child sub-form but nothing happens. there is no error message or anything. It just doesn't work.

	Kevin Robertson @Reply 5 years ago
The only advice I can really give you is check your spelling and for correct spacing. Do you have Option Explicit turned on? - a variable name may be mis-spelled. Is the record being added to the table? If it is you may only need to requery the SubForm. If you Message Box the value, is it displayed or is the message blank?

	Kevin Robertson @Reply 5 years ago

	Richard Rost @Reply 5 years ago
Yeah for the button to just do NOTHING is very unusual. Sounds like you put the VBA code in the wrong spot. I see you haven't taken any of my Developer courses. Did you watch Intro to VBA?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View