Covert Km,miles in one column

[Mile-O]

On a form's design mode goto

View -> Code

I'm worried, how did you put the Select Case code in before if you don't know how to get to a form's module?

 

[Mansoor Ahmad]

Thank you very much

I really really appreciate your patience and help.

Don't worry I did put the code at right place. It is just that I have never been very confident with codes because I am not professionally qualified in Access database or VB.

When I started building this database, I had basic understanding of MS access database and had never had my hands dirty with VB codes. I had no idea that it would involve that much of VB codes. I have learnt a lot in past few months but still a long way to go. That is why I have actually bought a VBA beginners book.

In this particular case it was just that I was not aware of the fact that the term 'module' is for all the codes in an object. So stupid of me.

Anyway I am pretty sure I would be able to solve the problem now.

Thanks for your help again.

 

[Mile-O]

Re: Thank you very much

I am not professionally qualified in Access database or VB.

Neither tham I.

 

[AccessAmateur]

Probably this doesn't really help with your problem but I have done a similar thing. I have a form where the user must enter dimensions. I want them to be in metres but often the information is often in inches or feet & inches. I set up so that the double click event opens a query which prompts the user to enter the value in inches then does the convert.
Using querys is a messy way but it does work. I'm trying to convert the query to code right now but keep having problems with this.