DoCmd function not working - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

DoCmd function not working

Stephanie Paul

3 years ago

Has anyone ran into an issue with DoCmd not working as it should. I set it to go to a specific record, but it keeps going to a blank record. I have two other fields that I set up that work fine. I've checked and they are exactly the same, I don't know why it's not working like the others. I made sure the field names matched the Subform and related table. Any suggestions? Pleeeeeeeease :-)

	Kevin Robertson @Reply 3 years ago
Code? Make sure Data Entry is set to No.

	Stephanie Paul OP @Reply 3 years ago
I don't see Data Entry in the settings, do you mean Enabled? or Locked perhaps?

	Stephanie Paul OP @Reply 3 years ago
I've tried deleting the field from the table and forms and adding several times from scratch but I can't figure it out. I've been at it for two days :-( Do you think it's a bug or something?

	John Davy @Reply 3 years ago

	John Davy @Reply 3 years ago
Take a look at your form. John

	Stephanie Paul OP @Reply 3 years ago
Thanks John, I found it and verified it's set to No. Do you think it's because I'm using a split form? It's just so weird that Im not have any problems with the two other fields that that I set the same command on. DoCmd.OpenForm "DetailOrderF", , , "PARTSID=" & PARTSID

	Stephanie Paul OP @Reply 3 years ago
And how do you paste pictures in here, that would be very helpful

	Kevin Robertson @Reply 3 years ago
Try adding acFormEdit to the command. `DoCmd.OpenForm "DetailOrderF", , , "PARTSID=" & PARTSID, acFormEdit` To add a screenshot click on the Upload Image button.

	Kevin Yip @Reply 3 years ago
If you see no record in the form, that means the filter returns nothing. Check if PARTSID has the value you expect, and that the filter "PARTSID=" & PARTSID actually returns something.

	Stephanie Paul OP @Reply 3 years ago
Thanks Kevin, I finally figured it out. I set the field to short test because it has dashes, I guess short text doesn't work with the the DoCmd function. Not sure sure, I'm very new to this so I'm leaning by trial and error. Thanks for your advice! I appreciate you :-)

	Kevin Yip @Reply 3 years ago
If PARTSID is text, you need quotes in the criteria: "PARTSID = '" & PARTSID & "'"

	Scott Axton @Reply 3 years ago
Stephanie - The answer to your question, "How do I upload pictures?" is right down at the bottom of the post. The Upload Images is a "button" that will allow you to select an image file from your computer. It is a separate process from typing in a response.

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

Next Unseen

New Feature: Comment Live View