Recent content by Dave1963

Pat, CJ, Rather than continue this thread ad nauseum I had commenced a new one that relates to the filtering of records and includes my latest trials and tribulations. Pat, I will research the where clause and come back when I have a handle on its use. Thanks for yopur guidance so far.

G'day again, This question follows on from my previous thread about finding a record to edit. I fell into what is probably a typical newbie trap. I had each of my forms open at a new record and then I was going to have the user search for the record that needed updating. What I found was that...

Aha. Thanks once again.

Riddle me this Batman. I have spent most of the day pouring over my reference texts and through old threads on the forum because whenever I type a value into the combo box the form does not go to the record that I am looking for. Then as I am about to give up, I notice, at the bottom of the...

A good night sleep does wonders. I realized that I am over thinking this one. KISS - Just list all of the states in the one field and report on one field not two. Forget about this one it is a non-event.

G'day Gurus, As I began thinking about the data that I need to include in one of my reports I relized that I need to gather some extra data. Each design change has a lifecycle with 7 basic states from not started through to closed. States 4, 5, and 6 have two posible sub-states that I need to...

G'day CJ, I did put the code into the After Update Event and I returned the Combo Box to an Unbound Control. The ComboBox quite happily cycles through the available record numbers just the way you said it would but the form itself does not go to the selected record even if I press enter or...

When I tried this, the form still did not move to the requested record. However, I changed the combo box from unbound to bound by setting the control source to the ECP Number field and now it works as advertised. My thoughts are that as an unbound box it would display the available records and...

I didn't know how to load just the form so here is the db I am trying to develop. At the moment I am only focussing on the data entry and data editing part of the program. There is one main table with three data entry forms. The forms are based upon who is required to enter data and at what...

I am dense aren't I. I changed the name of the unbound box to edit so of course it won't work as written. I changed the code to edit.Text but it still doesn't work. When I type the characters into the text box nothing happens in the form. I typed the full number (5 characters) into the box...

Thanks CJ. I must be particularly dense today because it didn't work. My form is set up almost as you assumed. Default View = Single form Recordset = Dynaset Dataentry = False Edits = true Cycle = current record (from Bob's suggestions on how to stop the tab key from moving on to a new record...

Pat, that is what I am trying to do. How do you select which record to edit?

You blokes are great. Bob's suggestion worked perfectly. CJ I tried to use the button wizard to "find" a record but it brings up the standard MS find dialog you get with ctrl+f. Can I create an edit record button that only looks in the ECPNo field for the record I want to enter? I tried the...

G'day Again Gurus, So far the advice I have received on these forums has worked a treat. I have created some control buttons using the built in functions of Access2007 and then using the script supplied here modified the control. So far the controls can add new record, save record, exit form...

I had drawn everything up on flip charts showing who does what etc and thought that I had reduced everything down to the minimum in others words, by applying engineering rigour to the plan I thought I had normalized the data and how it interacts. Your questions and points though, show me I have...