Total Nu-B question here!

[axsnub]

Hey All,

I must first apologize for my total stupidity when it comes to MS Access but this is something that should be soooo easy but I can't seem to figure it out for the life of me.

I'm working on a database and the two biggest issues I have at the moment are clearing all fields when I save the record or open up the form to enter new records. The second big issue I have is when I do a query I'd like for only the records belonging to the specified customer or location to be entered into the fields.

If anybody can help please respond and I can email you a basic mock-up of my current database in hopes that one of you magical people out there can help a poor guy out. This is for my mother-in-law so you can understand my panic. hehe

Thanks in advance for any help you can provide.


axsnub (Access Newbie)

 

[Uncle Gizmo]

>>>> clearing all fields when I save the record <<<<<

Please could you explain this in more detail.

 

[axsnub]

After racking my brains out about this it was as plain as the nose on my face. I was able to get this figured out by changing from a "Save Record" button to a "Add New Record" button.

However, I could still use some help on how to set up pop up messages that say a certain field must be filled in, also I would like to be able to go to that specific field when the user clicks "OK" on the pop up message. Is this possible?

 

[ghudson]

Your form should have both, a "Save Record" and an "Add new Record" button.

Search the forum for the key words "required" and "BeforeUpdate" to find one of a thousand threads related to your latter question.

You also should check out this recent thread...
http://www.access-programmers.co.uk/forums/showthread.php?t=82642