Search results

i got it...finally... just needed to add one field (fldtplan_label) to the "Combo_tplan On GotFocus" event ...ie... "select fldtplanid, fldtplan_brief_descritpion, fldtplan_label from tblmimtplan...... and in the control Text_Label i added =[Combo_brief].[Column](2) the entire code as...

i have tried using a different column number...i think the problem has to be in the Combo_tplan_GotFocus code...that seems to be the record source for the text_label..no matter what i do to the row source query..... for instance the "Combo_tplan_GotFocus" code pulls the field...

I have an unbound text box that i want to pull data into by selecting a record in a combo (the combo has the following code), Private Sub Combo_tplan_GotFocus() If IsNull(Me.Combo_standard) = True Then Me.Combo_tplan.RowSource = "select fldtplanid,fldtplan_brief_description from...

ureka!! that was exactly what i needed....thanks so much!!

i guess i am missing something here, the 1 is the criteria ..if fld_tplan_res_mat_id is 1 then i want the string (that follows) could it be i have the wrong syntax??? thanks for your help

sorry i dont see the typo

I have placed this Iif statement in the field line of a query ref: Iif([fld_tplan_res_mat_id],1([fldreference] & " " & [fld_free_text] & " " & [fldpages])," ") and am recieving this error "may have entered an invalid identifier or typed () following the null contant"

yes...that was what i was after ...it works now ONLY on the first time that i add a record upon opening the form....i will play with it and see what i can do....thanks again (everyone) for your help

i was wondering when someone would ask about why duplicate the data... well....a form i have that aligns the data has code that pulls from tblmimtplan....as hard as i have tried i could not figure out how to pull it from tbl_mimtplan...... so since tblmimtplan.fldmimtplan was just hanging...

sorry...but i am getting a bit confused the "value" should be the record that the form points to by making a selection in a combo box ...... i am trying to populate the record in tblmimtplan.fldmimid whose value is selected from a combo box on the form that also populates the same field in a...

now i get this error "Run time error '3077 Syntax error (missing operator) in expression" i assumed i was suppose to use either the string or digit code whichever applied....was this wrong? Private Sub ComboMIM_4_AfterUpdate() Dim db As dao.Database Dim rs As dao.Recordset Set db = CurrentDb...

is there a way to add a select statement (?) to the code (posted above)? i need to point to the specific record in tblmimtplan (tblTWO) fldmimid (fldA) which must be populated

the dao lib was ok i changed the relationship from enforcing ref integrity to not enforcing ref int.... that got it working... but still have an issue (of another type) i will try to work it out if i cant i may be back knocking on your door my apologies for not posting the error message...

below is the actual code i am using....this is resulting in some error messages....not sure if it matters but when i type in the code the first letter of each word is turning into a cap...i try to replace it with lower case but it keeps turning into a upper case letter..any ideas? Private Sub...

thank you very much i will try it first thing when i get to work in the a.m.

tblONE has fldA, fldB fldC tblTWO has fldA, fldX, fldZ (fldA representing same data) these tables are populated via a single form based on a query of tblONE and tblTWO tblONE fldA is populated using a combo box what i need to know is how do i populate tblTWO fldA simulaniously as tblONE fldA...

Wayne Thanks for the code, I am going to try it today.... regards plp

this is as i suspected, i am trying to do something outside the range of DCount...i did try create the a cross tab query and placed it in the form as a subform but i couldnt figure out the links to make it work....kept getting errors so i went back to the DCount...guess i will go back to the...

I will try to explain better...sorry for the confusion... i have a form that i use to add fldmimtplanid (lessons) to tblmimtplan as i add the tplans via this form, i want to see how many tplans i have entered based on grade level and core id (wu or fl) i have placed 2 text boxes on the form...

if i understand you right....i may be trying to do something that cant be done... there is nothing to compare it to...i want the value selected in Cmb_Grade to be the value that is used to do the count...along with the other criteria "fldmim_core_id=2"