Access Form

B

bp17

I would like to insert a "Y" into a subform field from the main form.
I tried using = insert [y] into «Expr» [warehouse table
subform].Form![Filled]
That didn't do anything
 
N

NetworkTrade

as no one has yet replied; the question is a little vague

Access is event driven. At what point in the user's activity in the form do
you want the Y to auto enter? Is the field single character such as Y or N
for Yes/No?
 
B

bp17

I apologize for the vague question, I am new to Access do please bare with me.
I would like create button in the form that "on click" would update the
feild name "filled" with in the a sub form. I only want a "Y" if null "N" is
assumed.

Thanks
BP17

NetworkTrade said:
as no one has yet replied; the question is a little vague

Access is event driven. At what point in the user's activity in the form do
you want the Y to auto enter? Is the field single character such as Y or N
for Yes/No?

--
NTC


bp17 said:
I would like to insert a "Y" into a subform field from the main form.
I tried using = insert [y] into «Expr» [warehouse table
subform].Form![Filled]
That didn't do anything
Click to expand...
Click to expand...
 
L

Linq Adams via AccessMonster.com

Syntax depends on where your button is located.

On the subform:

Me.Filled = "Y"

On the main form:

Me!YourSubFormControlName.Form!Filled = "Y"
 
B

bp17

I created the button and used "on click" and expression builder but I know
get an error message: The object doesn’t contain the Automation object ‘me’
What am I missing??
 
Top