Search results

Thank you for taking the time to explain.

Yes, I am going to use the auto numbering. My skills are not apt for other options at this point. I thank you all for your guidance.

I think I bit off more than I can Chew.

No I scrapped the reports and tried to adjust my tables and include the Course ID in every table so I could put it in a report by course ID. But that did not work. I think I am making more of a mess than I am solving my problems. So not I think I need to remove the Course ID from each table...

I was just hoping to not have the record number post if the record was not saved. I do not have to have sequential numbers. I realize there will be gaps if records are deleted.

Multi User, well if I ever get done. There is that.

Yes, I was trying to validate my report totals and am not able to stay scrolled to the bottom of the page. It bounces back to the first record

I have the following code written so that when a user does not want to save the data they entered they can opt not to save changes. I noticed that the autonumbering generates a number but does not save it. So if the user enters record # 4 and they decide not to save it the # 4 line item is...

Sorry, It was a general question. I did not know if there was a known bug. I am still working on the issue. I started over building the reports. If I have the same issue I will post more. Thanks.

Guys, when I nest my three sub reports in to the main report, I cannot scroll past the first record. It keeps bouncing back to the first record. Any help please.

Thank you. I finally got it to work!

Naw, I am doing something really wrong I cannot even get the query to run.

I have a main form which has a field ModuleID. This is a selection field. I would like the dropdown list on my sub form to limit the options based on the Module ID selected on the main form. Is that possible? I tried to do it in the query but was not successful...

Thank you Mike, most helpful.

You are correct, I mis-typed there. I am using a sub-form to select the role from a cbobox. Sorry for any confusion.

Yes, I can get the sub-form into the report, but the look and fill does not match. I was trying to get the sub-form data into a list box that would match the look and feel of the other fields in the report. I think, If I want the List box to be filtered by course catalogID, like the sub-form, I...

I have taken this approach as advised and the process seems to be working very well. It took me a minute to wrap my head around all the forms and sub-forms needed, but when faced with having to write VBA, well let's say I am not very good at that. The only issue I have faced, is getting the...

I am using sub reports to enter the data. The vba on the other hand is new tom. I will have to do a lot more research on theat. Thank you for the help.

Could you be more specific on circular referencing? I am still learning and am not sure i understand the concept.

What I want to see is the names of the roles assigned to the course. But I have to link the tables by ID.