Search results

Hi everyone again, Ok that’s a tough one. I’m building a soccer league database for my local league. There are tblTeams, tblPlayers, tblRoasters, tblPeriods, tblRounds, tblMatches, and tables tblHomeGoals, tblAwayGoals for keeping track of every match’s goal scorers. The way it is...

That seems to do the job. So easy but couldn't find it. Thank you so much CJ. Thank you all, you've been so helpful all these years.

Thanks, 1st suggestion looks good but, seems I can't manage to get the results the way I want. Tried linking MembersCount field but I'm getting all records twice. I only want all possible variations of the equal ones

Hi everyone again, I have a table with some data, the kind showing in the following image: I want to query (or whatever else needed) this table and get the groups having same number of members the way shown below: Group D Group E 8 Group D Group F...

Done it!!! Thank you Since Main Form opens, it creates a primary key, and takes some values as default. So record can be saved. I added a saverecord command before passing the open args value, and that was it! Thank you all You've been so helpful

Yes. tested it already and didn't work apparently because of this...any ideas?

Yeah, I forgot to say that Main form opens on Add mode so no existing record has to change

Nope, for an existing one, since it comes from another form anyway

OnLoad I suppose (main form's on load)

I'm asking how to use the Open Args value to populate the subforms control. There's no control in main form that can hold this value.

Let's say the main form holds invoice (number, date, recipient etc) and subform holds invoice details (product, value, etc). I want to open the main form passing a value to the product control on the subform. Main and subform are linked through InvoiceID.

Yah, but how?

I mean, main form and subform are related through other controls. The control to which I want to pass the open args value doesn't belong to the main form's record source.

Hi everyone, Suppose, closing a form, I want to pass a value to a control in opening form's subform. This subform control doesn't exist on opening main form. Is it doable and how? Thanks

Thanks for your reply too. I know what you mean and it's lovely. arnelgp's solution is functional too, being on the same path but, I find Minty's more 'educational' and keep it for future reference :).

Thank you all for your answers. I tried Minty's solution and works perfectly! Thanks again! You guys are wonderful.

That would premise that FormA is still open. And what happens when you open FormB by itself (not form the command button on FormA)?

Thank you!!! Looks promising. Haven't try it yet but looking at it a question comes up: What happens in case of 0|321 (that's the case when SupplierID is Null but CustomerID exists) That is, how to determine to which control of FormB to put the value Thanks

Hi everyone, I have two forms, FormA and FormB. On FormA I have two controls "SupplierID" and "CustomerID" that are comboboxes from which I select values respectively. On FormB there are the same two controls, only this time they are textboxes. With a command button on FormA I close FormA and...

isladogs your idea was perfect! I didn't use the OnChange event though, because there's also a NotInList event firing some code. I rather used the DoubleClick event just to prevent code from firing on an accidental click. Thank you all for your contribution!