|
|
Updating form automatically
Hello Everybody,
I have two columns in a table which are sources of dropdown boxes in a form.
In the form, when the value in one dropdown box is changed by the user, how
can I automatically update second dropdown box according to the data in the
table. For example in case of "copyone" as value in first dropdown box,
second drop down box has "paperone". When "copyone" is changed by "copytwo",
"paperone" should be changed with "papertwo". So far I am unable to do this
successfully either with SQL or VB. Any ideas will be highly appreciated.
--
Syed Zeeshan Haider
--------------------------------------------------------------------------------------------------------------------------------
Learn about famous muslim names at http://szh.20m.com/learn/aboutnames.html
|
|
0
|
|
|
|
Reply
|
 Syed
|
4/19/2007 5:07:10 PM |
|
See whether
http://office.microsoft.com/en-us/access/HA011730581033.aspx?pid=CH063650361033
helps.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Syed Zeeshan Haider" <szhatforumsDELETE@hotpop.SPAMS.com> wrote in message
news:%23vBISzpgHHA.3960@TK2MSFTNGP02.phx.gbl...
> Hello Everybody,
>
> I have two columns in a table which are sources of dropdown boxes in a
> form. In the form, when the value in one dropdown box is changed by the
> user, how can I automatically update second dropdown box according to the
> data in the table. For example in case of "copyone" as value in first
> dropdown box, second drop down box has "paperone". When "copyone" is
> changed by "copytwo", "paperone" should be changed with "papertwo". So far
> I am unable to do this successfully either with SQL or VB. Any ideas will
> be highly appreciated.
> --
> Syed Zeeshan Haider
>
>
> --------------------------------------------------------------------------------------------------------------------------------
> Learn about famous muslim names at
> http://szh.20m.com/learn/aboutnames.html
>
|
|
|
0
|
|
|
|
Reply
|
Douglas
|
4/19/2007 4:17:14 PM
|
|
|
1 Replies
214 Views
(page loaded in 0.031 seconds)
Similiar Articles: Automatically Updating a Field in a Form in Access - microsoft ...Hey Everyone, I am a bit of a noob at this, but have to build this database and would love some help if anyone can provide any. I have a database des... Making Automatic Updates in a form - microsoft.public.access ...First, I want to select the vendor name from a vendor table and then have the address lines update automatically. Second, in the child form I would like to enter a part ... How to automatically refresh a form - microsoft.public.access ...Automatically Updating a Field in a Form in Access - microsoft ... how to refresh form automatically after a particular interval ... Automatically Updating a Field in a ... Update a date/time control when check box control is updated ...... assuming Sold and Date Of Sale are actually controls on your form ... What is Java Update?... for Updates Automatically check box. To ... and the date and time for the ... Access 2007 Auto update Date - microsoft.public.accessI wish to update a date automatically in a form, after data has been changed. I have tried to do as the link belows shows, but I am not having any ... Form Automatic Refresh/Stay in Same Field - microsoft.public ...How to update Text form fields automatically by using the ... When you automate a form, text that you type into a Text form field appears automatically in other locations ... Using an update query to update amount in stock automatically ...Excel :: Update Query Automatically Update Query Automatically I have a form that laods when the ... Adding Up And Update Automatically I require a total amount of 'cost ... macro to run automatically when a field is updated - microsoft ...My question is: how could I make this field update automatically anytime a change is made anywhere on the form? Thank you for ANY assistance you can give! Getting an update query to run automatically - microsoft.public ...Automatically Updating a Field in a Form in Access - microsoft ... Need Query or Macro to Update Form - microsoft.public.access ... I have a form with two textboxes, both ... Query that updates automatically on screen - microsoft.public ...I have a database where students use a Form to sign in for computer help. I would like to have a queue displayed on another screen that shows the st... Introduction to updating existing form templates - InfoPath ...Update the forms automatically You can let InfoPath automatically update the existing forms, which is the default setting. In this case, any existing forms will match ... How to update Text form fields automatically by using the ...Guides you through the process of using the Calculate on exit option in Text form fields to perform calculations on exit. This option is very useful when ... Use Form To Update Table Automatically | MS Access[Archive] Question Use Form to update table automatically General Automatically update a formHi, I've got a split form that has 2 date entry boxes up the top ('From' and 'To'), and the data that is displayed in the table part runs through a query that Automatically Updating a Field in a Form in Access - microsoft ...Hey Everyone, I am a bit of a noob at this, but have to build this database and would love some help if anyone can provide any. I have a database des... 7/16/2012 11:16:49 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
71 followers. 