Search results

I have a form that has a combo box. When a value is selected in this combo box. My subform uses a query to get information based on what is selected in the combo box. There is no problem with getting this information. The problem is that I need to be able to change one of the field values on...

I have my db set up so that when you load all you see is the switchboard...no menus or tool bars. I have done this by going into startup and disabling them..no real trick there.. I have an option on my main switchboard to exit to design...from there it opens a form for a password, if the...

Thanks for the help i realized that i did not need that afterall but your suggestion would have worked

This might be confusing so I will try to give as much detail as possible. I have a table that has part numbers and the number of that part used that is based on a construction group lets call it. I have another table that has all the different products that we sell, it also contains the...

thanks jsut wanted to say thanks for answering this question. it saved me from posting this question again. all I had to do was search.

i got this without typing anything in Forms![frmNewOrder]![OrderNumber] that is the form name and field that i wanted

im not even typing anythign in, i am using the mouse and letting access tell me what fields are there and i am jsut selecting the one i want

i am trying to create an append query that gets 2 values from one table and a 3rd value from a form. It gets the values from the table fine but always gives me a popup asking for the value from the form. I have used the criteria build... and selected the loaded form and the field value that I...

I think what I am going to do is have it behind the scenes. The only reason I actually need it is for access. Thanks for the help everyone.

ok I have noticed that this is not a form problem but something that deals with the table. The table has the same autonumber problem. Does this help anyone see a simple solution

Ok this may seem very confusing as alot of things need to happen for what I am trying to do I am doing an inventory database that contains all order, client, purchasing, and inventory information. I have a table that has all of the different products we sell (also includes which of the...

What The Hell OK I got that to work so that I can input new records. Thanks for that. On the form that I open I am using an auto number to create client numbers. My table has numbers that go up to 18, but when I go to enter a new client, it is not 19. I think that my autonumber has counted up...

I want to make a form where I can only make a new record. I basically need a normal form that opens and automatically clicks the new record button. I do not want to be able to view and of the other records, only see the new record that I am putting in.

Hey thanks for the help. Ended up being that I had to have my code as Me.Refresh not Me!Refresh.

I am trying to make a form where the user selects a part number from a combo box. After the selection has been made I want to be able to see other information about the part. I have a table that has part number and description in it as well as a couple of other fields that I want to view. How do...