Subform to display data & allow entry

[Smitty]

I have a subform that displays General Ledger transaction data based on a ComboBox (Property Name) & Text Box for date selection on the main form. Simple enough, a user selects a department/date and the relevent transactions & GL codes for each property are returned in the subform.

What I'd like to do is allow the user to enter transaction amounts based on the date they select, with the previous day's entries displayed next to blank text boxes for current day's entries. Right now I have Current Day displayed as a "placeholder" from the subform query. Unfortunately, I'm a bit stumped as to what's going to be the best approach for adding text boxes for current day entries that are bound to the GL codes currently displayed. Once entered, the data can be written to the same transaction table that is feeding the current sub form.

I've been messing around with a second subform, but haven't had much luck so far.

Thanks!

 

[SydneyGeek]

Hi Smitty,

I'm guessing that you have a subquery for displaying Previous next to Current. In general subqueries are not data entry views. (Nor are Union queries, crosstabs, or Totals queries).

One solution is to have a button that launches a popup, filtered to the current record and based directly on the table. Once the user fills it in, close the popup and refresh the main view.

Denis

 

[Smitty]

Thanks Denis,

The problem is that the current record (day) hasn't been created yet, so previous day is a query tied to existing records.

I was actually able to add a second subform tied to an empty temp table, which looks like it'll work. Now I just need to see if I can synchronize scrolling between the two.

 

[SydneyGeek]

Take a look at The Access Web -- there is a page on the syntax for referencing one control from another, including subform to unlinked subform.
You can use that syntax in the Master / Child fields to sync the forms.

Denis

 

[Smitty]

Thanks Denis, I'll give it a go.