Search results

Pat, I guess I need to revist the query or have a rethink. When you say you don't get the problem, you mean, in principle, there should be a way to do this ? Not that you don't get why I want to do it ? Well, it's the clicking of the check box that is going to update the value on one side...

Thinking aloud about your work around suggestion: When the datasheet is presented to the user, insert a new record in tblSelectLines for EVERY datasheet record, and have an additional column called Selected. Put the actual field Selected in the datasheet and check/uncheck that real field in the...

Thanks for your further input. Here's the query which was generated in the query builder and tweaked, but it's now in the the VBA code for the parent form: strSQL = _ "SELECT tblTransLines.TransLineID, tblTransLines.tlTransHeaderFK, tblTransLines.tlNominalFK...

Not sure if I can do what I want. The check box is initially set by the SQL according to whether a record exists in a table. It doesn't exist as a field in either table. So there's nothing to update. Once the check box has displayed, I wanted to be able to click it. Then, if it's checked...

The check box is in a datasheet (so a checkbox for every record shown). I could put a control on the parent form which would do what I want for the highlighted sub form record but it's not really what I want. I tried the second checkbox bound to the yes/no but unfortunately that won't update...

The query which was built in the query designer, isn't updateable (just tested it) Both tables are indexed. tblSelectLines has only one column, the PK, and it's indexed. It has 1-1 relationship with tblTransLines. The insertion/deletion of records into tblSelectLines wouldn't happen by the...

Related to my last question https://www.access-programmers.co.uk/forums/showthread.php?t=309030 I have a SQL query which has an IIF which sets a form checkbox according to whether a record exists in a table. Like this...

Thanks, June7 (and all contributors). The check box is really just a flag to tell the app to write the record to tblSelections. To be honest I'm not sure how I'll deal with that yet because it doesn't need to exist as a field in the record in the be table. I think it can be done by creating a...

June7: Yes the 'selections' table will be in the front end so yes I've called it local (sorry wrong terminology). The issue? There may not be one. User checks (selects) a record in the be table, which happens to have an ID of 123. It's presented in a datasheet format with a checkbox. So I...

Can I re-use the PK for a record in a local table before a c & r is performed? Lots of questions and answers on variations of this question but they seem to be focussed on inserting records into an AutoNumber sequence which isn't what I want. I know that we don't normally use the PK for...

Great help, thanks MajP. Got the functionality I want.

MajP, I got your code pasted in to my various code/form modules and it works but I'm getting an issue with it. In frmInvoice (the called form) I put a command button like yours called 'Who Called Me' with a line to display the variable which is placed on the calling form. Once the called form...

Looking very promising, MajP, as I say I'll report back when I've got that coded in.

Thanks, MajP. I'm going to test that and report back but it may not be tonight. I agree about frmInvoice not caring about how it was opened, that is how it was designed, bar this issue. AcWindowMode isn't specified so I think that means AcWindowNormal. What's your preferred method (easy...

The called from, frmInvoice, refreshes the current record when I do DoCmd.OpenForm. DoCmd.OpenForm is quite happy to 'push' a new record into an already open form via a new WhereCondition. So the WhereCondition has a new record ID and frmInvoice, already open, just refreshes the record. It...

So for clarity: Getting the form name is a means to an end. Once it's been opened first time from frmIndex, the form name won't change for this session but txtTransLineID will, every time frmInvoice is refreshed with a different WhereCondition record. So the real question is how can...

I'm not averse to using TempVars or globals as such, I just regard them as a last resort. The open form may have been opened with a single record, with the index form still open underneath or to one side in Windows. The user may then select a different record in the index form, and it then...

Because OpenArgs is evaluated only on first open, not on subsequent openings and the params may be different. Just composing reply to DBguy...

Thanks for the quick response. Sort of. I found an old thread on here that said TempVars are only of use in SQL queries so I've avoided them. So far I haven't used TempVars or Global Variables. Plus, how would the different instance of the called form know which of the variables were the...

Is there a method for an open form to get the name of the calling form, so that it can read some parameters from the calling form ? I can't use OpenArgs as the form is already open. The open form may be called from different 'hosts' There may be an additional complication. Although I...