AfterUpdate problem

[Pete]

Hi, I have 2 Forms necessarily running off the same Query. In the first Form
I want a text box to fill automatically with certain data, and it does. In
the second Form I need that text box to remain Null - but of course it fills
with automated data. I have been trying to get the data in the text box
[Name] to be deleted and become Null after the text Box [ID] is updated, but
cannot get it to work.

Is it possible to provide me with a line of VB that would do this for me? I
would be most grateful.

 

[Jeanette Cunningham]

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can add a new
record?
If Yes, you can go to the form's property dialog | Data tab | Data Entry
Set the data entry property to yes. The form will open ready to add a new
record



Jeanette Cunningham -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it - it might be
confusing for users.
Maybe change its colour to match the form's background color to show them
that it is not for data entry.
You could also hide the control from the user - set its visible property to
No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second Form I
want
the [Name] to be Null, whereas in the First Form a Name is required. I
just
need to have the [Name] automatically deleted in the Second Form, or
better,
not added in the first place. I have been trying to do this via an
'afterUpdate' code. But maybe there is a better way.

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can add a new
record?
If Yes, you can go to the form's property dialog | Data tab | Data Entry
Set the data entry property to yes. The form will open ready to add a new
record



Jeanette Cunningham -- Melbourne Victoria Australia

Hi, I have 2 Forms necessarily running off the same Query. In the first
Form
I want a text box to fill automatically with certain data, and it does.
In
the second Form I need that text box to remain Null - but of course it
fills
with automated data. I have been trying to get the data in the text box
[Name] to be deleted and become Null after the text Box [ID] is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do this for
me?
I
would be most grateful.

 

[Jeanette Cunningham]

ps

If you are opening the form to an existing record and want to delete the
current value for Name, then in the form's load event you can set it to Null
like this:

Me.TheControlName = Null


Jeanette Cunningham -- Melbourne Victoria Australia

Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it - it might
be confusing for users.
Maybe change its colour to match the form's background color to show them
that it is not for data entry.
You could also hide the control from the user - set its visible property
to No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second Form I
want
the [Name] to be Null, whereas in the First Form a Name is required. I
just
need to have the [Name] automatically deleted in the Second Form, or
better,
not added in the first place. I have been trying to do this via an
'afterUpdate' code. But maybe there is a better way.

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can add a
new
record?
If Yes, you can go to the form's property dialog | Data tab | Data Entry
Set the data entry property to yes. The form will open ready to add a
new
record



Jeanette Cunningham -- Melbourne Victoria Australia


Hi, I have 2 Forms necessarily running off the same Query. In the
first
Form
I want a text box to fill automatically with certain data, and it
does. In
the second Form I need that text box to remain Null - but of course it
fills
with automated data. I have been trying to get the data in the text
box
[Name] to be deleted and become Null after the text Box [ID] is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do this for
me?
I
would be most grateful.

 

[Pete]

Sorry for my lack of clarity.
The underlying Query later provides the data for an Invoice. The first Form
records Time costs, for which a name is required – and there may be 100
records. The second Form records Expenses for which no Name is to be given –
and usually there is a small number of records. Even whenI lock the [Name]
cell or take the [Name] text box out of the second Form the query still
records the data in the Query background. So short of creating two separate
Queries, and therefore two separate Appends, is there any way I can delete
the [Name] data automatically in the second Form? I would like that text box
to remain Null for Expenses. All the advice you give is absolutely correct
but data has to be entered into each of the two Forms. Since hundreds are
filled out every day I am trying to automate as much as poss.
Just got your P.S. If you are opening the form to an existing record and
want to delete the
current value for Name, then in the form's load event you can set it to Null
like this:
Me.TheControlName = Null
This is close to a resolution of the problem except that new data is entered
into each Form. Can this be taken a step further to actually render Null the
data that later appears in the [Name] box?
Your help is appreciated.

ps

If you are opening the form to an existing record and want to delete the
current value for Name, then in the form's load event you can set it to Null
like this:

Me.TheControlName = Null


Jeanette Cunningham -- Melbourne Victoria Australia

Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it - it might
be confusing for users.
Maybe change its colour to match the form's background color to show them
that it is not for data entry.
You could also hide the control from the user - set its visible property
to No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second Form I
want
the [Name] to be Null, whereas in the First Form a Name is required. I
just
need to have the [Name] automatically deleted in the Second Form, or
better,
not added in the first place. I have been trying to do this via an
'afterUpdate' code. But maybe there is a better way.

:

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can add a
new
record?
If Yes, you can go to the form's property dialog | Data tab | Data Entry
Set the data entry property to yes. The form will open ready to add a
new
record



Jeanette Cunningham -- Melbourne Victoria Australia


Hi, I have 2 Forms necessarily running off the same Query. In the
first
Form
I want a text box to fill automatically with certain data, and it
does. In
the second Form I need that text box to remain Null - but of course it
fills
with automated data. I have been trying to get the data in the text
box
[Name] to be deleted and become Null after the text Box [ID] is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do this for
me?
I
would be most grateful.

 

[Pete]

Merci bien. I have just applied your principle with an afterUpdate piece of
code: Me.FETimekeeper_Name = Null
The Name is duly rendered Null. Thanks Jeanette.

ps

If you are opening the form to an existing record and want to delete the
current value for Name, then in the form's load event you can set it to Null
like this:

Me.TheControlName = Null


Jeanette Cunningham -- Melbourne Victoria Australia

Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it - it might
be confusing for users.
Maybe change its colour to match the form's background color to show them
that it is not for data entry.
You could also hide the control from the user - set its visible property
to No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second Form I
want
the [Name] to be Null, whereas in the First Form a Name is required. I
just
need to have the [Name] automatically deleted in the Second Form, or
better,
not added in the first place. I have been trying to do this via an
'afterUpdate' code. But maybe there is a better way.

:

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can add a
new
record?
If Yes, you can go to the form's property dialog | Data tab | Data Entry
Set the data entry property to yes. The form will open ready to add a
new
record



Jeanette Cunningham -- Melbourne Victoria Australia


Hi, I have 2 Forms necessarily running off the same Query. In the
first
Form
I want a text box to fill automatically with certain data, and it
does. In
the second Form I need that text box to remain Null - but of course it
fills
with automated data. I have been trying to get the data in the text
box
[Name] to be deleted and become Null after the text Box [ID] is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do this for
me?
I
would be most grateful.

 

[Jeanette Cunningham]

Pete,
I'm glad you got it sorted.
However I am concerned that there could be an underlying problem with your
table set up.
The scenario you needed help with is very unusual. I don't know how much you
rely on this database - but if you care to post your table details, we could
check it out.


Jeanette Cunningham -- Melbourne Victoria Australia

Merci bien. I have just applied your principle with an afterUpdate piece
of
code: Me.FETimekeeper_Name = Null
The Name is duly rendered Null. Thanks Jeanette.

ps

If you are opening the form to an existing record and want to delete the
current value for Name, then in the form's load event you can set it to
Null
like this:

Me.TheControlName = Null


Jeanette Cunningham -- Melbourne Victoria Australia

Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it - it
might
be confusing for users.
Maybe change its colour to match the form's background color to show
them
that it is not for data entry.
You could also hide the control from the user - set its visible
property
to No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second Form
I
want
the [Name] to be Null, whereas in the First Form a Name is required. I
just
need to have the [Name] automatically deleted in the Second Form, or
better,
not added in the first place. I have been trying to do this via an
'afterUpdate' code. But maybe there is a better way.

:

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can add a
new
record?
If Yes, you can go to the form's property dialog | Data tab | Data
Entry
Set the data entry property to yes. The form will open ready to add a
new
record



Jeanette Cunningham -- Melbourne Victoria Australia


Hi, I have 2 Forms necessarily running off the same Query. In the
first
Form
I want a text box to fill automatically with certain data, and it
does. In
the second Form I need that text box to remain Null - but of course
it
fills
with automated data. I have been trying to get the data in the text
box
[Name] to be deleted and become Null after the text Box [ID] is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do this
for
me?
I
would be most grateful.

 

[Pete]

You may be right. I can post the Table relationships or a zip of the program.
Where should I post them to?

Pete,
I'm glad you got it sorted.
However I am concerned that there could be an underlying problem with your
table set up.
The scenario you needed help with is very unusual. I don't know how much you
rely on this database - but if you care to post your table details, we could
check it out.


Jeanette Cunningham -- Melbourne Victoria Australia

Merci bien. I have just applied your principle with an afterUpdate piece
of
code: Me.FETimekeeper_Name = Null
The Name is duly rendered Null. Thanks Jeanette.

ps

If you are opening the form to an existing record and want to delete the
current value for Name, then in the form's load event you can set it to
Null
like this:

Me.TheControlName = Null


Jeanette Cunningham -- Melbourne Victoria Australia

Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it - it
might
be confusing for users.
Maybe change its colour to match the form's background color to show
them
that it is not for data entry.
You could also hide the control from the user - set its visible
property
to No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second Form
I
want
the [Name] to be Null, whereas in the First Form a Name is required. I
just
need to have the [Name] automatically deleted in the Second Form, or
better,
not added in the first place. I have been trying to do this via an
'afterUpdate' code. But maybe there is a better way.

:

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can add a
new
record?
If Yes, you can go to the form's property dialog | Data tab | Data
Entry
Set the data entry property to yes. The form will open ready to add a
new
record



Jeanette Cunningham -- Melbourne Victoria Australia


Hi, I have 2 Forms necessarily running off the same Query. In the
first
Form
I want a text box to fill automatically with certain data, and it
does. In
the second Form I need that text box to remain Null - but of course
it
fills
with automated data. I have been trying to get the data in the text
box
[Name] to be deleted and become Null after the text Box [ID] is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do this
for
me?
I
would be most grateful.

 

[Jeanette Cunningham]

Type a post with
-table name
-primary key
-foreign key
-a couple of other important fields

for each of the main tables, as an answer to this post.


Jeanette Cunningham -- Melbourne Victoria Australia

You may be right. I can post the Table relationships or a zip of the
program.
Where should I post them to?

Pete,
I'm glad you got it sorted.
However I am concerned that there could be an underlying problem with
your
table set up.
The scenario you needed help with is very unusual. I don't know how much
you
rely on this database - but if you care to post your table details, we
could
check it out.


Jeanette Cunningham -- Melbourne Victoria Australia

Merci bien. I have just applied your principle with an afterUpdate
piece
of
code: Me.FETimekeeper_Name = Null
The Name is duly rendered Null. Thanks Jeanette.
:

ps

If you are opening the form to an existing record and want to delete
the
current value for Name, then in the form's load event you can set it
to
Null
like this:

Me.TheControlName = Null


Jeanette Cunningham -- Melbourne Victoria Australia

Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it - it
might
be confusing for users.
Maybe change its colour to match the form's background color to show
them
that it is not for data entry.
You could also hide the control from the user - set its visible
property
to No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second
Form
I
want
the [Name] to be Null, whereas in the First Form a Name is
required. I
just
need to have the [Name] automatically deleted in the Second Form,
or
better,
not added in the first place. I have been trying to do this via an
'afterUpdate' code. But maybe there is a better way.

:

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can
add a
new
record?
If Yes, you can go to the form's property dialog | Data tab | Data
Entry
Set the data entry property to yes. The form will open ready to
add a
new
record



Jeanette Cunningham -- Melbourne Victoria Australia


Hi, I have 2 Forms necessarily running off the same Query. In
the
first
Form
I want a text box to fill automatically with certain data, and
it
does. In
the second Form I need that text box to remain Null - but of
course
it
fills
with automated data. I have been trying to get the data in the
text
box
[Name] to be deleted and become Null after the text Box [ID] is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do
this
for
me?
I
would be most grateful.

 

[Pete]

TblClient (1-M, TblMatter)
Company_ID (Pr Key)
Client_Name
Client_address

TblMatter (1-M, TblTimeAndExpense)
Law_Firm_Matter_ID (Pr Key)
Client_ID (FrKey)
Matter_Name

TblTimeAndExpense
Line_Item_Number (Pr Key)
Line_item_task_code (FrKey
Line_item_expense_code (Frkey)
Timekeeper_ID (Frkey)
Line_item_total

TblFE (1-M, TblTimeAndExpense)
FETimekeeper_ID (Pr Key)
FETimekeeper_Name

TblTaskCode (1-M, TblTimeAndExpense)
Line_item_task_code (Pr Key)
Task

TblExpenseCode (1-M, TblTimeAndExpense)
Line_item_expense_code (Pr Key)
Expense

Thanks for your interest, appreciated.

Type a post with
-table name
-primary key
-foreign key
-a couple of other important fields

for each of the main tables, as an answer to this post.


Jeanette Cunningham -- Melbourne Victoria Australia

You may be right. I can post the Table relationships or a zip of the
program.
Where should I post them to?

Pete,
I'm glad you got it sorted.
However I am concerned that there could be an underlying problem with
your
table set up.
The scenario you needed help with is very unusual. I don't know how much
you
rely on this database - but if you care to post your table details, we
could
check it out.


Jeanette Cunningham -- Melbourne Victoria Australia


Merci bien. I have just applied your principle with an afterUpdate
piece
of
code: Me.FETimekeeper_Name = Null
The Name is duly rendered Null. Thanks Jeanette.
:

ps

If you are opening the form to an existing record and want to delete
the
current value for Name, then in the form's load event you can set it
to
Null
like this:

Me.TheControlName = Null


Jeanette Cunningham -- Melbourne Victoria Australia

Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it - it
might
be confusing for users.
Maybe change its colour to match the form's background color to show
them
that it is not for data entry.
You could also hide the control from the user - set its visible
property
to No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second
Form
I
want
the [Name] to be Null, whereas in the First Form a Name is
required. I
just
need to have the [Name] automatically deleted in the Second Form,
or
better,
not added in the first place. I have been trying to do this via an
'afterUpdate' code. But maybe there is a better way.

:

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can
add a
new
record?
If Yes, you can go to the form's property dialog | Data tab | Data
Entry
Set the data entry property to yes. The form will open ready to
add a
new
record



Jeanette Cunningham -- Melbourne Victoria Australia


Hi, I have 2 Forms necessarily running off the same Query. In
the
first
Form
I want a text box to fill automatically with certain data, and
it
does. In
the second Form I need that text box to remain Null - but of
course
it
fills
with automated data. I have been trying to get the data in the
text
box
[Name] to be deleted and become Null after the text Box [ID] is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do
this
for
me?
I
would be most grateful.

 

[Jeanette Cunningham]

Pete,
I had a quick look over the table and structure.
It looks normalized - good.
I can see why the problem with the Timekeeper name.
I can't see how TblMatter is related to TblTimeAndExpense.
Maybe Law_Firm_Matter_ID is a foreign key in TblTimeAndExpense, but the
relationship is just not shown in the post?

I presume FETimekeeper_Name is the person in the law firm who is dealing
with the matter.


Jeanette Cunningham -- Melbourne Victoria Australia

TblClient (1-M, TblMatter)
Company_ID (Pr Key)
Client_Name
Client_address

TblMatter (1-M, TblTimeAndExpense)
Law_Firm_Matter_ID (Pr Key)
Client_ID (FrKey)
Matter_Name

TblTimeAndExpense
Line_Item_Number (Pr Key)
Line_item_task_code (FrKey
Line_item_expense_code (Frkey)
Timekeeper_ID (Frkey)
Line_item_total

TblFE (1-M, TblTimeAndExpense)
FETimekeeper_ID (Pr Key)
FETimekeeper_Name

TblTaskCode (1-M, TblTimeAndExpense)
Line_item_task_code (Pr Key)
Task

TblExpenseCode (1-M, TblTimeAndExpense)
Line_item_expense_code (Pr Key)
Expense

Thanks for your interest, appreciated.

Type a post with
-table name
-primary key
-foreign key
-a couple of other important fields

for each of the main tables, as an answer to this post.


Jeanette Cunningham -- Melbourne Victoria Australia

You may be right. I can post the Table relationships or a zip of the
program.
Where should I post them to?

:

Pete,
I'm glad you got it sorted.
However I am concerned that there could be an underlying problem with
your
table set up.
The scenario you needed help with is very unusual. I don't know how
much
you
rely on this database - but if you care to post your table details, we
could
check it out.


Jeanette Cunningham -- Melbourne Victoria Australia


Merci bien. I have just applied your principle with an afterUpdate
piece
of
code: Me.FETimekeeper_Name = Null
The Name is duly rendered Null. Thanks Jeanette.
:

ps

If you are opening the form to an existing record and want to
delete
the
current value for Name, then in the form's load event you can set
it
to
Null
like this:

Me.TheControlName = Null


Jeanette Cunningham -- Melbourne Victoria Australia

message
Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it -
it
might
be confusing for users.
Maybe change its colour to match the form's background color to
show
them
that it is not for data entry.
You could also hide the control from the user - set its visible
property
to No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second
Form
I
want
the [Name] to be Null, whereas in the First Form a Name is
required. I
just
need to have the [Name] automatically deleted in the Second
Form,
or
better,
not added in the first place. I have been trying to do this via
an
'afterUpdate' code. But maybe there is a better way.

:

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can
add a
new
record?
If Yes, you can go to the form's property dialog | Data tab |
Data
Entry
Set the data entry property to yes. The form will open ready to
add a
new
record



Jeanette Cunningham -- Melbourne Victoria Australia


Hi, I have 2 Forms necessarily running off the same Query. In
the
first
Form
I want a text box to fill automatically with certain data,
and
it
does. In
the second Form I need that text box to remain Null - but of
course
it
fills
with automated data. I have been trying to get the data in
the
text
box
[Name] to be deleted and become Null after the text Box [ID]
is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do
this
for
me?
I
would be most grateful.

 

[Pete]

Thanks, Sorry omitted that TLaw_Firm_Matter_ID is a foreign key in
TblTimeAndExpense. You are correct in thinking that
FETimekeeper_Name is the person in the law firm who is dealing
with the matter. The Program has benefitted from your alert since as a
result of checking all relationships some Form errors previously missed were
corrected.

TblMatter (1-M, TblTimeAndExpense)
Law_Firm_Matter_ID (Pr Key)
Client_ID (FrKey)
Matter_Name

TblTimeAndExpense
Line_Item_Number (Pr Key)
Line_item_task_code (FrKey
Line_item_expense_code (Frkey)
Timekeeper_ID (Frkey)
Line_item_total
TLaw_Firm_Matter_ID (FrKey)

Pete,
I had a quick look over the table and structure.
It looks normalized - good.
I can see why the problem with the Timekeeper name.
I can't see how TblMatter is related to TblTimeAndExpense.
Maybe Law_Firm_Matter_ID is a foreign key in TblTimeAndExpense, but the
relationship is just not shown in the post?

I presume FETimekeeper_Name is the person in the law firm who is dealing
with the matter.


Jeanette Cunningham -- Melbourne Victoria Australia

TblClient (1-M, TblMatter)
Company_ID (Pr Key)
Client_Name
Client_address

TblMatter (1-M, TblTimeAndExpense)
Law_Firm_Matter_ID (Pr Key)
Client_ID (FrKey)
Matter_Name

TblTimeAndExpense
Line_Item_Number (Pr Key)
Line_item_task_code (FrKey
Line_item_expense_code (Frkey)
Timekeeper_ID (Frkey)
Line_item_total

TblFE (1-M, TblTimeAndExpense)
FETimekeeper_ID (Pr Key)
FETimekeeper_Name

TblTaskCode (1-M, TblTimeAndExpense)
Line_item_task_code (Pr Key)
Task

TblExpenseCode (1-M, TblTimeAndExpense)
Line_item_expense_code (Pr Key)
Expense

Thanks for your interest, appreciated.

Type a post with
-table name
-primary key
-foreign key
-a couple of other important fields

for each of the main tables, as an answer to this post.


Jeanette Cunningham -- Melbourne Victoria Australia



You may be right. I can post the Table relationships or a zip of the
program.
Where should I post them to?

:

Pete,
I'm glad you got it sorted.
However I am concerned that there could be an underlying problem with
your
table set up.
The scenario you needed help with is very unusual. I don't know how
much
you
rely on this database - but if you care to post your table details, we
could
check it out.


Jeanette Cunningham -- Melbourne Victoria Australia


Merci bien. I have just applied your principle with an afterUpdate
piece
of
code: Me.FETimekeeper_Name = Null
The Name is duly rendered Null. Thanks Jeanette.
:

ps

If you are opening the form to an existing record and want to
delete
the
current value for Name, then in the form's load event you can set
it
to
Null
like this:

Me.TheControlName = Null


Jeanette Cunningham -- Melbourne Victoria Australia

message
Pete,
just lock the textbox for Name. (property dialog | data tab)
A locked control means that the user can't type anything in it -
it
might
be confusing for users.
Maybe change its colour to match the form's background color to
show
them
that it is not for data entry.
You could also hide the control from the user - set its visible
property
to No (property dialog | format tab)


Jeanette Cunningham -- Melbourne Victoria Australia

Both are Entry Forms. I should have explained that in the second
Form
I
want
the [Name] to be Null, whereas in the First Form a Name is
required. I
just
need to have the [Name] automatically deleted in the Second
Form,
or
better,
not added in the first place. I have been trying to do this via
an
'afterUpdate' code. But maybe there is a better way.

:

Pete,
does the first form open in edit mode?
Do you want the second form to open in add mode so the user can
add a
new
record?
If Yes, you can go to the form's property dialog | Data tab |
Data
Entry
Set the data entry property to yes. The form will open ready to
add a
new
record



Jeanette Cunningham -- Melbourne Victoria Australia


Hi, I have 2 Forms necessarily running off the same Query. In
the
first
Form
I want a text box to fill automatically with certain data,
and
it
does. In
the second Form I need that text box to remain Null - but of
course
it
fills
with automated data. I have been trying to get the data in
the
text
box
[Name] to be deleted and become Null after the text Box [ID]
is
updated,
but
cannot get it to work.

Is it possible to provide me with a line of VB that would do
this
for
me?
I
would be most grateful.