Does my database's front end need to be done in VB?

Edit: I'm highly sorry moderators, I've just thought that this thread might be better placed in the Access Sub-Forums. Please would it be possible to move it if you feel it is necessary.

Hi there,

I'm rather new here. A good friend of mine known as RadioactiveFrog pointed me to here as I have a query regarding a db I want to create.

Basically I am working on a project to work as an Enquiry/Ordering System/database for the company I work for.

We have lots of different type of enquiry with different options depending on what type of project it is supposed to be.

So when the user is entering the enquiry or order into the system I need it to change the available options that the user can enter, in real time.

I.e. if one radio box is clicked, then some options become available and others get greyed out or disappear, and if a different one is clicked, then different options appear relevant to it, and the other ones disappear.
So "if statements" applenty!

Now my initial thoughts were to use MS Access (due to me not knowing MySQL or PHP etc) but Graham - RadioActiveFrog suggested it would be more like a VB front end. I don't know if you can do if statements in Access, but I know you can in VB.

Many thanks in advance for your help.

Si

You can definitely do If statements in Access. It uses VBA as the programming language and for more sophisticated Access projects you HAVE to use VBA in at least some circumstances.

Put them on the "after update" event of your option buttons or something like that.

Syntax for or if/else:

IF (this is true) THEN
Make this happen
Else
make this happen
End If

Caution - if a value in your "this is true" section is a null, VBA does not like it. You have to have a value, even if it is zero or "", in order to evaluate a statement.