Lookup without code

[cinders]

Hi There,

I am trying to create a form that has a text box. I want to be able to input a value into that text box and have it lookup whether that ID exists in my table. If it does I would like it to open a form that is populated with that ID and relevant information. If the ID does not exist, I would like a message box to indicate that the ID does not exist and would the user like to add it. I would like a button on the message box for the user to click that will take them to a form that allows them to add the new ID and details. Is there a simple way to do this without writing a bunch of code?

If not, is there someone who can step me through this in clear laymans terms as I have no coding experience?

AND if you could recommend any really good books for people wanting to learn and understand code I would really appreciate it.

Thanks

Cindy

 

[VBITS]

Sorry to be the messenger, but it cannot neetly without VBA-Coding...

If you want to learn more about VBA coding there are some ways to learn. As VBA is quite simple (Certainly to English native speakers), you could install the NorthWind database from the Office CD, it contains lots of usefull coding examples.

Also a usefull tool for VBA Novices (and lasy Masters), it's the key comby CTRL-Space, when you hit those keys a list of all commands, variables etc. which are available, It's really easy to experiment...

Lots of success

(By the way, it's the way I learned it this way, now I work as a VBA, VB and .NET programmer )