Recent content by Chaz

Tend to agree. I think Id need to rewrite the database based on stuff I did wrong and learnt along the way. Its likely Im leaving this company (I hope) in which case I wont need to do any work on it - so will see what happens before I redo it.

Yes, but there is no relationship - perhaps there should be but I was getting 'recordset cannot be updated' issues when I tried to co-join the two tables. So at the moment the TNE number in the hardware tab is shown after a query is run to show what TNE number in the top combo field. Perhaps...

Thank you kindly.

Theres such a thing? Lol - just never bothered to look. Could probably just write a batch file but too lazy.

Simplest way (and assuming this is what you are looking for) is as follows: 1. Frontend database either on your user's machine or a network location. 2. Backend of the database on an accessible share somewhere on your network. The front and backend are 'connected' by a linked table (manager)...

Just tested - it works as JBG said, but the link is then broken back into the table. so what happens is that new records are created in the hardware table, but the TNE number is not carried through.

A further issue is that the control source of the TNE field is already set. t_hardware_orders.HW_TNE_Number So I would assume that I cannot overwrite it to say =Form(details elsewhere) as I would lose the link between the TNE number and the table?

This is the query that is used to show the hardware orders, specific to this TNE (Technical Network Element - fwiw). SELECT t_hardware_orders.*, t_hardware_orders.HW_TNE_Number FROM t_hardware_orders WHERE (((t_hardware_orders.HW_TNE_Number)=[Forms]![f_tne_master]![cb_tne_number]));

The subform is not linked as such. The data for the subform is created by a query that looks up the TNE number in the top header and then displays it there. Ill try the code that you have put - seems reasonable but not sure if it will work. The data in the core form and all the tabs on the left...

My noobish input, your tables will be saving a number anyways to represent ABC company, changing the name in the company table does nothing with the number and will therefore be replicated through the database. t_company PK_ID (Autonumber) Name t_table1 PK_ID (Autonumber) CompanyName (Number)...

Anyone please?

Maybe an image will help explain what im trying to do. On the right - you can see the records shown on the basis of the queried field. On the left, if someone started to add a new record here, how could I get it to 'autopopulate' the TNE number field?

Sorry, not sure what title to use. I have a form with multiple tabs. The one tab is Hardware. This form, based on a query, shows all hardware orders related to this 'TNE Number'. This TNE Number is on the 'header' of the main form. So, when there are records, normally 3-5, these show no...

Yep, I love talking to myself. Let me practice some 'Netherlands'. Ja, ek hou daarvan om met myself te praat. I changed the code a bit to look at another condition and use conditional formatting to colour the text box on the result of the number calculated. Code (hardly)...

Ok, that seems to work - thank you kindly.