Datasheet views

[G. Miller]

Hey. Normally I play with something until I get it, but this form
needs to be finished by tomorrow. Here's what I'm trying to do (form
is in datasheet view):

1) Hide a field and assign it a value from a control file when a
record is added.

2) Open the form in add mode. They want to start at the bottom of the
list.

3) When "Section" field is entered, the field "location" becomes a
required entry.

Any ideas? I'm not used to working with a form in datasheet view.
Thanks.

[Keith W]

"G. Miller" <gm*****@nospam-mobileregister.com> wrote in message
news:43*****************@newsgroups.bellsouth.net. ..

Hey. Normally I play with something until I get it, but this form
needs to be finished by tomorrow.
Homework time again? ;-p
Here's what I'm trying to do (form
is in datasheet view):

1) Hide a field and assign it a value from a control file when a
record is added.
Don't understand the question.

2) Open the form in add mode. They want to start at the bottom of the
list.
In design view, change the "Data Entry" property to "yes".

3) When "Section" field is entered, the field "location" becomes a
required entry.

You'd need a bit of code attached to form's Before Update event that tests
for null in both text boxes and handles the outcome accordingly (air code):

If Not IsNull(Me.txtSection) And IsNull(Me.txtLocation) Then
MsgBox "Enter a Location"
Me.txtLocation.SetFocus
Cancel = True
End If

HTH - Keith.
www.keithwilby.com

[G. Miller]

Heh, lots of homework....thanks Keith. That's what I was looking for.

On Tue, 8 Nov 2005 16:53:09 -0000, "Keith W" <he**@there.com> wrote:

"G. Miller" <gm*****@nospam-mobileregister.com> wrote in message
news:43*****************@newsgroups.bellsouth.net ...

Hey. Normally I play with something until I get it, but this form
needs to be finished by tomorrow.

Homework time again? ;-p

Here's what I'm trying to do (form
is in datasheet view):

1) Hide a field and assign it a value from a control file when a
record is added.

Don't understand the question.

2) Open the form in add mode. They want to start at the bottom of the
list.

In design view, change the "Data Entry" property to "yes".

3) When "Section" field is entered, the field "location" becomes a
required entry.

You'd need a bit of code attached to form's Before Update event that tests
for null in both text boxes and handles the outcome accordingly (air code):

If Not IsNull(Me.txtSection) And IsNull(Me.txtLocation) Then
MsgBox "Enter a Location"
Me.txtLocation.SetFocus
Cancel = True
End If

HTH - Keith.
www.keithwilby.com