Microsoft Access help?

Question

Hey, I am creating a database for a college project and need a bit of help. When something is typed into a certain textbox on a form, I want another textbox/field to be completed automatically. For example, when 'Build' is typed into 'Job Type' I want the 'Estimated Length' box to automatically have '8' written in it, and so on.
Any help is gratefully received as I'm really stuck!

Answer 1

In The Form Design Window Click on the Menu View ---> Code
then Choose From the First Menu "Job Title" or the Field name then choose from the other menu "AfterUpdate"
these lines will appear
Private Sub jobtitle_AfterUpdate()

End Sub

Now Write between the two lines this code :

If [jobtitle] = "Build" Then
[EstimatedLength] = 8
End If

and if you have an idea about the "Visual Basic" Language this will make it easier for you

Answer 2

Not too sure what you are trying to do but if it's within access you will need to attach a code to your form that automatically updates every time the text box with build in it is updated using the onAfterUpdate function.
What you are looking to do is go to the form design and double click on it, this should give you some tabs including the 'event' tab. Use this to define what happens after the tab is updated.
Hope this helps

Answer 3

Download the Northwind sample database, which includes this as a tutorial.

http://www.microsoft.com/downloads/details.aspx?FamilyID=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=en&hurl=A2A283764D4F2F99B9EC3E401C4C505E&QueryID=1FmATwRwp0&respos=1&rt=2&pid=CD010226021033

http://office.microsoft.com/en-gb/access/HA010546951033.aspx?pid=CH011508321033

Answer 4

You will probably need to do some coding in vbscript to get that result.

Answer 5

http://office.microsoft.com/en-gb/access/default.aspx

Hope this link may help you