The SSO - Reached Waters of State is the form name.
Here is a copy of the current event code:
Private Sub Form_Current()
Me.CategoryName = "Test"
End Sub
I got another error - "Compile error: Method or data member not found."
The debugger highlighted: ".CategoryName ="
Thanks
:
Do this. Copy the info on the OnCurrent event and I will look at it.
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
:
Thanks all for responding. I definetly appreciate the help.
I tried typing [SSO - Reached Waters of State].CategoryName = "Test" in the
on current event in the form properties. When I opened the form it gave me
an error - "Run-time error '2465': Microsoft Access can't find the field
'l' referred to in your expression. Any ideas?
:
Hi Cyberwolf,
I pick out & answer the really easy questions and leave you clever lot to
concentrate on the hard questions
TonyT..
:
Thanks for responding Tony. I appreciate it.
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
:
Hi Omaha,
The Me. refers to the current form saves having to type
Forms!.FormName.Control to reference each control on the current form.
To let VB or SQL know there are spaces enclose the field or control name
with [] eg; Me.[Control Name With Spaces In]
TonyT..
:
Another dumb question, Im not so great with VB, what if there are spaces how
do you let vb now that it is one string of characters
:
I was assuming you were doing this on a new record. In design view go to the
forms On Current Event and create a new procedure to look like this
Private Sub Form_Current()
Me.Test = "Test"
End Sub
where me.Test equals your fields name
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
:
I have tried to do that in the form's design view, I simply type in the text
I want into the default value box, surrounded by quotes, but nothing shows up
in the text box when i go to data entry mode, and nothing is entered into the
field in the table unless I manually type it in. I can enter the default
value in the table design view and I need it entered into a specific form
because each form has a different default value for that text box
:
In design View click on the field you want to have the default value. and
look at the properties and find the Default value property and add the value
you want.
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
:
I am having a problem setting the default value for a text box in a form. I
have 8 forms; each form applies to a certain category name. I want a text
box in the form to have a default value of the category name, so that the
user does not have to type anything it will just populate to the categoryname
field in the table, I am going to lock the field so it can not be changed.
When I set the default value property for the textbox inside the form design
view, nothing shows up (in the form or in the table) No matter what I try I
keep getting blank values in the categoryname field.
I can't set the default value in the Table Design because it has multiple
values.
I'm not for sure if this makes sense or if I have a bad design idea, I am
fairly new to access. Any help would be greatly appreciated