How To Default Information On Form?

Topic

New Reply

I’m looking to build a form in which once a value from a drop-down box is selected, the next field in the form auto-populates with a predefined value. I’m experiencing a tremendous brain-fart I know, but I am drawing a blank. For anyone who assists, I’m pretty new to Access, so I could use as much detail as possible. Thanks and have a nice weekend. Pete

Reply | Quote

Replies

Pete,

for someone new to access, there are several great sites around (including, of course, this one!). You could do worse than look at Access Archon; Item 6 may be relevant.

If you want to keep it really simple, in the After Update of the combo box, use:

[indent]If nz(cmbWhatever,0) 0 then

[indent][/indent][indent][/indent]targetcontrolname=DLookup(x,y,z).

end if[/indent]

Dlookup is slow, but relatively easy to use. Check the Help. Just remember that speech marks are needed.

Or, if the value really is predefined and will not change, replace the DLookup with a Select Case statement.

[indent]Select Case nz(cmbWhatever,0)

Case x

[indent][/indent]targetcontrolname=xxx

Case y

[indent][/indent]targetcontrolname=xyz

Case Else

[indent][/indent]targetcontrolname=null

End Select[/indent]

Regards,

Jules

Reply | Quote

I’m looking to build a form in which once a value from a drop-down box is selected, the next field in the form auto-populates with a predefined value. I’m experiencing a tremendous brain-fart I know, but I am drawing a blank. For anyone who assists, I’m pretty new to Access, so I could use as much detail as possible. Thanks and have a nice weekend. Pete

In the AfterUpdate event of your combobox, you’d need code. What code depends on the situation. For example, do you want to autopopulate the next field any time the combobox changes, or just when that next fields is null?

Reply | Quote

In the AfterUpdate event of your combobox, you’d need code. What code depends on the situation. For example, do you want to autopopulate the next field any time the combobox changes, or just when that next fields is null?

I would want to autopopulate the next field any time the combobox changes; your help is appreciated Pete

Reply | Quote

JulesG – thank you. I’ll work on this as well as the URL you suggest. MarkLiquorman, thank you too.

Reply | Quote

Thank you so much for your help; I had some syntax issues with DLOOKUP but have been able to resolve. Please consider this matter closed.

Reply | Quote