Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Have existing text when form opens 1

Status
Not open for further replies.

officemanager2

Technical User
Oct 11, 2007
116
CA
I'm trying to get a form to open up using a button click (done)

But also I would like the form to have some text preloaded when it opens up, such as 'Sent latest update'

and subsequently have that preloaded text saved to the field that ties into the form, along with any other notes the input user may wish to add when they save/close the form.

Thought this would be simple as it is easy to input preloaded text to the body of an email from access but I'm stumped on this one.

I've been using DoCmd.OpenForm "FormName" for the click to get things going but can't seem to create anything to preload text for the field.

Any suggestions?

 
What about the DefaultValue property of the form's control ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Hi: I'm trying that but it is not working the way I would like because the notes are also tied into other input buttons.

This type of note is specific to this button so I was hoping to input it (the note) when the button is pushed.

The note field has an open default setting but the button default setting is either yes or no which I can't get to work in the direction I'm currently going.

The overall idea is that whoever is doing input only has to push one button and the note around this specific type of update being sent to them appears in the overall note section. If they wish to add to the note they can, but at the very least the note is logged in the same list as the other notes from other input buttons.
 
What about something like this ?
DoCmd.OpenForm "FormName"
DoEvents
Forms![FormName]![overall note control] = "Sent latest update"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
I'm trying that now, but admit to being confused about

[overall note control]

I'm unsure what this is (and too be honest I don't know the entire functionality of [] brackets?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top