Recent content by Lanser

Hi Pat, A variation of what I have aleady except at the moment I am using a button and the P_NewRec sub with unbound controls in the subform header to add data into the subform and then requery to get the latest record at the top. The issue is no matter how I try to call the P_NewRec sub with...

Thanks Gemma, but the searching is ok was hoping to get my little bit of code to work with adding a new result to the dynamically loaded subform. Maybe I need to reconsider my original idea of showing/hiding controls on just one subform depending on category

Almost yes, but at the moment they have 3k cards all in alphabetical order by product code, so they just look for the code it doesnt matter what category it is. The cards are set up by a different team. I only have two categories set up in the database so far but to have 7 different ones will...

Trying to make the UI as familair as poss to the users, currently they use pen/paper filing card system. with different cards for different product groups. I was trying to avoid having seperate forms for each group It was working as expected with the single subform but adding the dynamic...

Sorry for delay in responding I have been away. The command button is on the main form but in order to keep the most recent data at the top of the subform I am using unbound controls in the header of the subform. I've attached the database fe and be with some sample data

Apologies I forgot to say thanks your solution works although it has created a second problem I an using some code (P_NewRec)i n the subforms module attached to a button on the main form to transfer data from unbound controls into the subform but now I get a runtime error 2105 you can't go to...

I thought it was quite clear. main form is frmMain linked to multiple products each with their own targets and results subforms are frmTarg_672 and frmRes_672 Target subform frmTarg_672 contains fields for target minimum and maximum e.g. trg_Salt, trg_Salt_Min and trg_Salt_Max Results...

Hi I have a main form with 2 linked subforms one showing targets and one in continuous forms view showing results, how can I get the results fields to be highlighted if values above or below values in equivalent target fields? I tried using conditional formatting but it doesnt work. regards John

Hi Searched but cant find the correct answer I have a main form, that contains the product details and two subforms that show targets and results. I have half a dozen different porduct types that have different criteria and rather than try and cram all the criteria on one subform I want to show...

I probably used the wrong word they are not really common fields One product will have one fixed Target but many variable results is why I split the tables i.e the targ_Ph field will always be 3.2 but the res_Ph field will have a different result for each batch of that product tested. regards John

Hi, thanks for the fast response. I basically have four tables for products, results, targets and groups. Results and targets have 17 matching fields which are used in a variety of combinations across the groups hence the messyness when I tried to do it on one subform. John

Hi, I have googled but can't find a solution. I have a main form for each product that would like to contain 2 subforms one containing targets for each product and one for results. The Target subform will be fixed targets and the results subform will be for editing/adding results.. FrmMain...

data entry is managed by a different form so I also set the field in the underlying table to required and a default of 12 months Using Nz was a belt and braces in case any user found a way round and because never used before :)

Hi Tammy, If you look at the Database I uploaded to it contains a search form that filters on multiple fields and narrows as you type look for the frm_searchMulti and the code behind the text boxes. I can't claim the code but was so long ago I can't remember where I found it. regards John...

Thanks that fixed it and looking back maybe it was working before because I was opening the forms from the nav pane rather that the switchboard