Need input & VBA code on Best Way to Idea

[momaw nadon]

I'm looking for VBA code to help me get started on and idea. Basically I have a drop down with 3 options on a form (not sure if I will need this information within my table or not), but need it to pull up a window to input depending on which option is selected. One selection of the options if selected will not require the input of data, as it can just input a set value or be left blank (haven't totally figured how I want to display it). With all this I will need it to display on a form in a certain format, in which I would like the drop down value displayed with the data inputted, though with the one option without data just would display drop down value. Sorry if this sounds crazy, I have just been trying to figure out ways to make this work for so long and can't come up with anything without wanting to pull my hair out.

Thanks for any assistance
momaw nadon

 

[JLCantara]

I think you should first make up your mind and then, ask for help. Is this form your talking about exists? If so, post screenshots of it.

 

[jdraw]

momaw nadon,
I think you have to get a clear description of WHAT you are trying to do. I think your thinking at the moment is somewhere between What and How. Get the WHAT clearly defined, then move on to options as to how this might be accomplished with Access.

 

[momaw nadon]

My problem is I have been over thinking this whole thing. Its hard to put words to it. Sorry I didn't clearly define what I was asking.

I have this database, that needs to be updated to include more information now. I need to change a memo field that you were able to just input the data, that now will need to be in another table also. To make things easier so the use will not need to input the data twice and cut down on error, I would like to use a drop down. It is a repair database, so the 3 options will be in (where its located), repair (from that location), or deployable (fixed and awaiting use). With the drop down selection "in", I would like it to pull up another form (windowed) to input that location. If "repair" selected, just need the option to correct the location there or leave as is, but with deployable, the location would just become blank or omitted. Just wondering if someone can give me some pointers on where to start from, as everything I have started so far just fails miserable. I hope that better describes my needs.

Thanks
momaw nadon

 

[jdraw]

You are still describing How you intend to do something. It is the something we need to get clear before identifying options.

made up example of what I'm suggesting.
You have inherited a database that supports "some sort of maintenance repair facility". A change to the way data is entered has been suggested. We currently do a,b and c and record info in a memo field. The proposal is to allow x, y and z so that we can - (more refined reports/better statistics improve resource allocation...)
" whatever the rationale is goes here".

Perhaps you could post a jpg of your tables and relationships, and/or tble designs...