adding a new customer
in [Queries]
|
From: bhrosey via AccessMonster.com on 29 Apr 2010 11:23 Ok, I have been away from Access for a couple years now and was only a moderate user to begin with. I am trying to build a database in 2007 that has several details or fields about a product. I have a drop down list of customers to choose from in the customer field, but if an operator comes across a customer that is not in the list, what is the easiest way for them to add it to list? I don't want them to have to retype if possible, but that's not critical. I am not real good at code, so is there an easy way to do this with queries or macros? Thanks for the help. -- Message posted via http://www.accessmonster.com
From: Allen Browne on 29 Apr 2010 21:28 In form design view, right-click your combo. Set its List Items Edit Form property (on the Data tab of the Properties box) to the name of the form where you add new customers. The user can then right-click the combo and choose Edit List Items to add a new customer. More details and other alternatives in this article: Adding values to lookup tables at: http://allenbrowne.com/ser-27.html#PopUpForm -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "bhrosey via AccessMonster.com" <u33878(a)uwe> wrote in message news:a742a1684a2fb(a)uwe... > Ok, I have been away from Access for a couple years now and was only a > moderate user to begin with. I am trying to build a database in 2007 that > has several details or fields about a product. I have a drop down list of > customers to choose from in the customer field, but if an operator comes > across a customer that is not in the list, what is the easiest way for > them > to add it to list? I don't want them to have to retype if possible, but > that's not critical. I am not real good at code, so is there an easy way > to > do this with queries or macros? Thanks for the help. > > -- > Message posted via http://www.accessmonster.com >
|
Pages: 1 Prev: Query crosses 3 tables Next: Need null values for several fields in db |