Creating a input form...?

[DarrenReeder]

Hello,

I have currently got three main things..

(1) A query that gets information on a customer in my tables
(2) A report which looks like a invoice..
(3) A Switchboard

Basicly i want to make a drop down box which shows the names of all the users in my database OR a input box to enter the name or something of someone then when i press enter it looks for the user and it will use that query in the report for me..



-thanks for any help...

[ajetrumpet]

combo boxes display based on their sql statements in the recordsource property. so that'll do you for that.

to assign the value you get from an input box, you would write:

variable = inputbox("please insert username")

and of course you can use that var in a dlookup() function to get records out of a dataset using it in the criteria section.

[DarrenReeder]

Right, so where is all this code written? Thats the one thing that i dont entirely understand.. i understand how to code (I have used Pawn, Java, C++, Javascript, PHP etc..) but im not sure exactly where this code is written..

[ajetrumpet]

the code is written in the vb editor, Darren. since you've got the 07 version, to get there simply push Alt+F11 or go to database tools tab > visual basic.

all the code is written there for stand alone, and split apps that don't source to a server somewhere. but that's not all you need to do if you want the code to function with other objects.

for instance, if you write a procedure that needs to execute when a form loads, you cannot simply write:

private sub form_load()
'do something here
end sub

in the form's module in the vb editor. It won't happen until you go into the property sheet and click those little elipsis (...) beside that event name to link that code to the object specifically.

it's much different than php or js, as access has a separate resource and screen for scripting.

[DarrenReeder]

Mhmm, ive used VB quite a bit before, not extensively though.. Ill take a look into VB a bit and ill try out what you recommended..

thanks for help mate, ill comment back here in the next few days if i have any trobules