Search results for query: *

I'm not certain I understand exactly but I think I have the idea. Instead of control source, do an after update event for the Text11 and 13 similar to this. If they are on different forms you will have to specify the form If Not IsNull(Text11) Then Me.Text12.Value = Me.Text11 If Not...

one table lists all possible options for any class/day/time available. When the user selects it, i want it to store under that student ID so that the student is then registered in this class. I must be making this seem way too hard cuz I know in 2000 this is simple stuff i just cant get the...

Please tell me what is the correct syntax for acess 97 to: The user selects from a combo box to fill a text box. I want the field of the non-data source table to say exactly what is populated from the combo box. It should be something like this: If Not IsNull(Text1) Then...

???? i guess i am not posing the question corectly. this is a simple thing so i cant be describing it correctly. i will repost

i am obviously not describing my question correctly i will repost

are you using access97?

you can do an after update even on the combo box to populated the fields you want with the information. the syntax is different for access97 and access 2000 so id have to know which you are using. is the datasource for the form the same as the datasource in which you wish to store the final...

are you using access '97 or 2000? is the listbox populating a text box on your form? how did you tell listbox1 to populate listbox 2?

ok i see your response now but it doesnt need a query and such i just need the correct syntax to call the table and field in access 97

Hi i am used to 2000 but am using '97. I have a form which uses a combo box from a table that lists all possible classes/days/times for students to enroll. When the user selects the class, i would like to store the information in a different table for that student id. I am trying: If Not...

i dont see your name on my post so i reckon you didnt.

thanks for your help but i have to call the table i want it stored in. the datasource for the combo box is a table which lists all classes available. When the user chooses the class/day/time i need it to store in another table called registration. so in my code i need the syntax to define the...

I am using access 97. I have a form based on the classschedule table with a combo box from which the user can select a certain class/date/time. After the class is selected I would like the info stored in the classregistration table under the studentID. I am trying to use the following but it...

I am using access 97. I have a combo box from a classschedule table from which the user can select a certain class/date/time. After the class is selected I would like the info stored in the classregistration table under the studentID. I am trying to use the following but it isn't quite right...

I'm using '97 and havent' for a while. Could someone please give me a hint on syntax to fill a table field from a form. I have tried If Not IsNull(Me.Combo1) Then Table![Registration]![Class]!.Value = Me.Combo1.Column(1) I know this is close but i have something wrong with how I have...

Thank you. I guess I forgot the me! Thank you so much!

I am working with Access 97 and havent' in a long time. I can't remember the wording to have the combo box selection populate the text box. It is something like If Not IsNull(combo10) Then text1.value = combo10.column(2) But this is off somehow because it is debugging every time i try this...

I'm sorry I am brain dead. This is probably easy but I have been working all weekend. ACCESS97 I have a form that I want to add a text box that populates from another table than the one the form is based on. I put a text box on the form and in the control source i built an event =table!etc...

I'm sorry. It did work!!! Thank you!

I copied and pasted the formula into the query. It "runs" but does not update the Running TOH field. I guess I am confused because the query is doing arithmetic but now with infinity and there is an exact answer. ????