Form Design

Cindy

Registered User.
Local time
Today, 08:50
Joined
Jul 3, 2014
Messages
160
help! I used the button wizard to create my SAVE button but it is not working. It is not updating the table. My DELETE button clears the form but does not remove the record from the table. Could someone please advise what I'm doing wrong?
 
"It's not working" plus the code or macro would be nice.
 
yes sorry. I have attached a sample of the SAVE macro. I found that it Saves only when the table is closed. Didn't do that before when I had the other code. However it still does not clear the page after I click on Save. Could you advise on what to add to make it do that please?

The DELETE button does not work when I type the ID on the form.
 

Attachments

  • ButtonCODE.jpg
    ButtonCODE.jpg
    46 KB · Views: 80
  • ButtonCODE2.jpg
    ButtonCODE2.jpg
    48.2 KB · Views: 76
Okay it looks like I spoke too soon. Please put it down to newcomer excitement. Turns out that they work as long as the Table is closed.

How can I make the form auto populate by typing the ID into a textbox control please?
 
How can I make the form auto populate by typing the ID into a textbox control please?
That's another discussion. You know we like our threads:)

When you post, what you want to ask for is something along the lines of "search as I type" because you're asking about a search functionality.
 
Perhaps I should be more specific. My table has a compound key consisting of Trip_ID and Patient_ID. The form also has a combo box and many tab controls. I want the form to pull up the data from the Table when I type in the compound primary key. I really appreciate any help on this one.
 
ah! yes master:) that is what I meant "Search as I type"
 

Users who are viewing this thread

Back
Top Bottom